{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Introductory page","1 Current state of the building","2 Design of the roof","3 Results","What's next","NCW Financieel","NCW MKBA","Prijspeil","Waterretentie Groen dak","Waterretentie","Luchtkwaliteit en klimaat","Gezondheid","Imago en vestigingsklimaat"],"not_rendered":{"charts":9,"images":32,"macros":1,"external_links":0,"defined_names":6,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Introductory page","index":0,"n_rows":40,"n_cols":15,"rows_kept":40,"cut":false,"hidden":false,"merged":[[33,4,33,12],[34,4,34,12],[36,4,36,12],[11,2,11,12],[5,2,7,12],[8,2,8,6],[30,9,30,11]]}
[]
[]
[null,null,"Calculation tool Multifunctional roofs (v2.0)"]
[]
[null,null,"Introduction",null,null,null,null,null,null,null,null,null,null,null,"Client"]
[null,null,"Are you a building owner and considering the construction of a multifunctional roof. With this tool, you will have insights into the financial businesscase and the social costs and benefits of a multifunctional roof. For more information about multifunctional roofs, please visit:"]
[]
[]
[null,null,"https://duurzaam010.nl/product/daken"]
[]
[null,null,"Aim"]
[null,null,"This tool is designed to provide users insights into the financial businesscase and the social costs and benefits of a multifunctional roof."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Partners"]
[null,null,"The process"]
[null,null,"This tool consists of three steps"]
[]
[null,null,"Step 1: Enter your data of the current state of the building and its roof."]
[]
[null,null,"Step 2: Enter the characteristics of your design for the multifunctional roof."]
[]
[null,null,"Step 3: Results for the financial businesscase and the social cost-benefit analysis. ",null,null,null,null,null,null,null,null,null,null,null,"Part of"]
[]
[null,null,"The presented steps correspond to the sheets at the bottom of this introductory page."]
[]
[]
[]
[]
[null,null,"Colofon"]
[null,null,"This tool has been made possible through financial support from the European LIFE-program."]
[]
[null,null,"Municipality of Rotterdam:",null,"Sustainability program",null,null,null,null,"duurzaam@rotterdam.nl",null,null,"010-4895489"]
[]
[null,null,"The tool is developed by Arcadis and CE Delft."]
[null,null,"Projectteam Arcadis:",null,"Jeroen Klooster (jeroen.klooster@arcadis.com), Robert de Kort (robert.dekort@arcadis.com),"]
[null,null,null,null,"Jolijn Posma (jolijn.posma@arcadis.com), Douwe Fischer (douwe.fischer@arcadis.com),"]
[null,null,null,null,"Andy Bruijns (andy.bruijns@arcadis.com)"]
[null,null,"Projectteam CE Delft:",null,"Geert Warringa (warringa@ce.nl)"]
[]
[null,null,"Version 2.0",null,"May 2021"]
[null,null,"LIFE-projectnumber: ",null,"LIFE16CCA/NL/000096"]

{"sheet":"1 Current state of the building","index":1,"n_rows":34,"n_cols":24,"rows_kept":34,"cut":false,"hidden":false,"merged":[[24,8,27,12],[32,8,33,12],[3,2,3,11]]}
[]
[null,"Data current state of the building and its roof",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"l personen in huishouden","Gemiddeld gebruik per jaar","Kosten per maand in €*"]
[]
[null,null,"Instructions: \nThe tool has been designed to use in about 10 minutes. Please fill al the yellow fields for the tool to work. To assist you in the proces, we have entered as many standard prices and default values as possible. You are free to change these if that will better reflect your specific case. "]
[]
[null,null,"Project"]
[null,null,"Project name",null,null,null,null,null,null,null,null,null,null,null,{"$f":"F7","v":0}]
[null,null,"Version",null,null,null,null,null,null,null,null,null,null,null,{"$f":"F8","v":0}]
[null,null,"Date",null,null,{"$f":"TODAY()","v":"2021-06-02"},null,null,null,null,null,null,null,null,{"$f":"F9","v":"2021-06-02"}]
[null,null,"Variant",null,null,null,null,null,null,null,null,null,null,null,{"$f":"F10","v":0}]
[]
[null,null,"Current roof",null,null,"input",null,null,null,null,null,null,null,null,null,null,"Bron: Milieu Centraal en RVO (berekening Nibud, 2020)"]
[null,null,"Surface area",null,null,null,"m²"]
[null,null,"Replacement period roof  (every X years)",null,null,25,"year",null,null,null,null,null,null,null,null,null,"*Bij een gemiddeld elektriciteitstarief (tarief na 1 januari 2020) van 22,54 eurocent per kWh en vastrecht van € 24,66 per maand (incl. 21% BTW). Inclusief de jaarlijkse belastingteruggave van € 527,17 (2020). Afgeronde bedragen."]
[null,null,"Replacement costs current roof",null,null,45,"per m² without tax",null,null,null,null,null,null,null,null,null,"-",1825,15,null,null,null,null,"opnemen als baat  (vermeden kosten)"]
[null,null,"Maintenance costs current roof",null,null,4,"per m² without tax",null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,"Default waarde gebruiken"]
[null,null,"Frequency of maintenance (every X years)",null,null,1,"year",null,null,null,null,null,null,null,null,null,2,2860,34,null,null,null,null,"https://www.dakdekker-weetjes.nl/kosten-dakbedekking/#:~:text=Voor%20een%20dak%20van%2060,lang%20mee%2C%20namelijk%2025%20jaar."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,"Current functionality of the building",null,null,null,null,null,null,null,null,null,null,null,null,null,4,3400,45]
[null,null,"Size of household (if relevant)",null,null,"-","persons",null,null,null,null,null,null,null,null,null,5,3930,55]
[null,null,"Current power usage ",null,null,null,"KWh per year",null,null,null,null,null,null,null,null,null,null,4180,59]
[null,null,"Type of neighbourhood",null,null,"Hoogbouw",null,null,null,null,null,null,null,null,null,null,"Bedrijf"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gemiddeld per huishouden","2.832 kWh",34]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Keuze menu met wijktypologieën vanuit klimaateffectatlas"]
[]
[null,null,"Current value of the building"]
[]
[]
[]
[null,null,"Total surface area of the multifunctional roof"]
[null,null,"Total surface area of the multifunctional roof",null,null,null,"m²"]
[]
[null,null,"Multifunctional roof as part of larger construction project"]
[null,null,"Investment costs of total construction project"]

{"sheet":"2 Design of the roof","index":2,"n_rows":193,"n_cols":36,"rows_kept":193,"cut":false,"hidden":false,"merged":[[12,2,12,4],[14,2,14,4],[15,2,15,4],[4,2,4,4],[6,2,6,4],[8,2,8,4],[10,2,10,4],[11,2,11,4],[15,12,15,14],[17,2,17,4],[45,6,47,8],[56,6,57,8],[34,6,36,8]]}
[]
[]
[null,"Data for design of the new roof"]
[null,"Which functions will your roof fullfil?"]
[null,null,"Green roofs",null,null,null,null,null,null,null,null,{"$f":"C5","v":"Green roofs"},false,{"$f":"IF(M5=TRUE,\"Ja\",\"Nee\")","v":"Nee"}]
[null,null,"Green roofs provide a green environment and are useful in cases of extreme dry, hot and wet weather."]
[null,null,"Blue Roofs",null,null,null,null,null,null,null,null,{"$f":"C7","v":"Blue Roofs"},false,{"$f":"IF(M7=TRUE,\"Ja\",\"Nee\")","v":"Nee"},null,null,null,null,2]
[null,null,"Blue roofs collect and store water. They play an important role with very wet or dry weather.",null,null,null,null,null,null,null,null,null,null,null,null,null,"hebben we alle functies staan"]
[null,null,"Yellow roofs",null,null,null,null,null,null,null,null,{"$f":"C9","v":"Yellow roofs"},false,{"$f":"IF(M9=TRUE,\"Ja\",\"Nee\")","v":"Nee"},null,null,"Kosten",1,"https://youtu.be/7OeNDSepbUY?t=31"]
[null,null,"Yellow roofs generate renewable energy from the sun or the wind. "]
[null,null,"Red Roofs ",null,null,null,null,null,null,null,null,{"$f":"C11","v":"Red Roofs "},false,{"$f":"IF(M11=TRUE,\"Ja\",\"Nee\")","v":"Nee"},null,null,"Kosten"]
[null,null,"Red roofs have a social function. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ja","Nee"]
[null,null,"Orange roofs  ",null,null,null,null,null,null,null,null,null,false]
[null,null,"Orange roofs are used for transport and mobility.",null,null,null,null,null,null,null,null,null,false]
[null,null,"Purple roofs"]
[null,null,"Purple roofs consist of living space.",null,null,null,null,null,null,null,null,null,false]
[null,null,"Grey roofs are for technical installations."]
[null,null,"Financial contributions of third parties."]
[]
[null,"Green roofs provide a green environment and are useful in cases of extreme dry, hot and wet weather."]
[null,null,null,null,null,null,null,"Invoer"]
[null,null,null,null,"How much surface area would you like to cover?",null,null,0,"m²"]
[null,null,null,null,"How many people have a view onto your roof?",null,null,"0 tot 10","persons"]
[null,null,null,null,"Are you combining multiple types of green roofs?",null,null,"Yes"]
[null,null,null,null,"If you select \"No\", the tool will assume you will use a extensive or sedum-roof. ",null,null,null,null,null,null,null,null,null,"dakvlakken toelichten: meerdere typen groen dak op het dak"]
[null,null,null,null,"What type of green roof would you like to use?",null,null,null,null,null,null,null,null,null,"multifunctionele daken.nl i.p.v. deze link?"]
[null,null,null,null,null,null,"Type 1","Type 2","Type 3",null,null,null,null,null,"duurzaam010.nl",null,null,null,null,null,"Baten (koppelen aan aparte tabbladen per baat)"]
[null,null,null,null,null,null,"Sedumroof","Nature roof","Roof garden",null,null,null,null,null,null,null,null,null,null,null,"Biodiversiteit: kwalitatief en mogelijk toepassen puntensysteem Max Klasberg (verkennen met Aster)"]
[null,null,null,null,null,null,"*multiple types are possible"]
[null,null,null,"Sedumroof",null,null,"Costs"]
[null,null,null,null,0,"m²","Investment costs",50,"per m² without tax",null,null,null,null,null,"https://groendaktotaal.nl/sedumdak-prijs.html?gclid=Cj0KCQjwo6D4BRDgARIsAA6uN18TEG1MnFGqIxtw8QyomnaqYDjxsPAnvj3k0PbYelRerr10wm69WroaAmicEALw_wcB"]
[null,null,null,null,null,null,"Yearly maintenance costs",1.2,"per m² without tax"]
[null,null,null,null,null,null,"Replacement period (after X years)",60,"Year",null,null,null,null,null,"Yes",null,null,null,null,null,"Gezondheid: koppelen aan aantal mensen die kunnen kijken op dak"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[null,null,null,null,null,null,"An extensive green or sedum roof system contains vegetation, ranging from sedums to small grasses, herbs and flowering herbaceous plant. "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sedumroof",null,null,null,null,null,"Gezondheid: koppelen aan aantal mensen die kunnen kijken op dak"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nature roof"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roof garden"]
[null,null,null,"Nature roof"]
[null,null,null,null,0,"m²","Costs","Invoer"]
[null,null,null,null,null,null,"Investment costs",75,"per m² without tax",null,null,null,null,null,null,null,null,null,null,null,"Gezondheid: koppelen aan aantal mensen die kunnen kijken op dak"]
[null,null,null,null,null,null,"Yearly maintenance costs",{"$f":"H42*0.02","v":1.5},"per m² without tax"]
[null,null,null,null,null,null,"Replacement period (after X years)",30,"Year"]
[]
[null,null,null,null,null,null,"A nature roof contains vegetation with trees, shrubs, herbs grasses or other perannial plants, preferably indigneous.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Gezondheid: koppelen aan aantal mensen die kunnen kijken op dak"]
[]
[]
[]
[]
[null,null,null,"Roof garden",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gezondheid: koppelen aan aantal mensen die kunnen kijken op dak"]
[null,null,null,null,null,"m²","Costs",null,null,null,null,null,null,"Plaatjes van Rotterdamse daken toevoegen"]
[null,null,null,null,null,null,"Investment costs",90,"per m² without tax"]
[null,null,null,null,null,null,"Yearly maintenance costs",{"$f":"H53*0.02","v":1.8},"per m² without tax",null,null,null,null,null,"0 tot 10"]
[null,null,null,null,null,null,"Replacement period (after X years)",30,"Year",null,null,null,null,null,"10 tot 50",null,null,null,null,null,"Gezondheid: koppelen aan aantal mensen die kunnen kijken op dak"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50 tot 100"]
[null,null,null,null,null,null,"A roof garden contains vegetation with grasses, perennial plants, shrubs and trees. The roof can be used as a meeting area or for recreational use.",null,null,null,null,null,null,null,"meer dan 100"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gezondheid: koppelen aan aantal mensen die kunnen kijken op dak"]
[]
[null,null,null,null,"Total"]
[null,null,null,null,"Surface area green roof",null,null,{"$f":"IF((E52+E41+E31<1),H22,(E52+E41+E31))","v":0},"m²",null,null,null,null,null,null,null,null,null,null,null,"Gezondheid: koppelen aan aantal mensen die kunnen kijken op dak"]
[null,null,null,null,"Investment costs",null,null,{"$f":"IF(H24=\"Nee\",(H22*H31),IF(H62>0,MROUND((H53*E52)+(H42*E41)+(H31*E31),100),0))","v":0},"without tax",null,null,null,null,null,null,null,null,null,null,null,"Vastgoedwaarde: afhankelijk van type wijk (zie invoer huidige situatie) en hoe groen het al is"]
[null,null,null,null,"Maintenance costs",null,null,{"$f":"IF(H24=\"Nee\",(H22*H32),IF(H62>1,MROUND((H54*E52)+(H43*E41)+(H32*E31),10),0))","v":0},"without tax per year",null,null,null,null,null,null,null,null,null,null,null,"Hittestress inpandig kwalitatief"]
[]
[]
[null,"Blue roofs collect and store water. They play an important role with very wet or dry weather."]
[null,null,null,null,null,null,null,"Invoer"]
[null,null,null,null,"Will your roof collect and store rainwater?",null,null,"Yes"]
[null,null,null,null,"Investment costs",null,null,80,"per m² without tax ",null,null,null,null,null,null,null,null,null,null,null,"Default waarde instellen"]
[null,null,null,null,"Maintenance costs",null,null,1,"per m² without tax per year"]
[null,null,null,null,"How many square meters do you intend to construct?",null,null,0,"m²",null,null,null,null,"conditionalis format ting, bij geen invoer lichtgeel, bij geldige invoer lichtgroen"]
[null,null,null,null,"How many mm water will your roof store?",null,null,50,"mm"]
[null,null,null,null,"Replacement period (after X years)",null,null,30,"Year"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Instellen op default waarde",null,null,null,null,null,null,"Baten (koppelen aan aparte tabbladen per baat)"]
[null,null,null,null,"Do you intend to reuse the stored water?",null,null,"No","Ja/nee",null,null,null,null,"Yes",null,null,null,null,null,null,"Baten (koppelen aan aparte tabbladen per baat)"]
[null,null,null,null,"How much of the stored water do you intend to reuse?",null,null,{"$f":"H73/1000*H72*1000","v":0},"liter (total)",null,null,null,null,"No",null,null,null,null,null,null,"Vermeden kosten alternatieve waterberging"]
[null,null,null,null,"Water utilities rate",null,null,0.85,"per m³",null,null,null,null,null,null,null,null,null,null,null,"Minder watergebruik voor irrigatie"]
[null,null,null,null,"What is your intended use for the collected water?",null,null,"Irrigatie",null,null,null,null,null,"Niet",null,"Grijswater als optie weglaten; alleen irrigatie"]
[]
[null,null,null,null,"Total"]
[null,null,null,null,"Water retention",null,null,{"$f":"H73/1000*H72","v":0},"m³"]
[null,null,null,null,"Investment costs",null,null,{"$f":"H70*H72","v":0},"without tax"]
[null,null,null,null,"Maintenance costs",null,null,{"$f":"H71*H72","v":0},"without tax per year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Irrigatie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grijswater"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vermeden kosten alternatieve watervoorziening",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Niet"]
[null,"Yellow roofs generate renewable energy from the sun or the wind. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waterkwaliteit: minder overstorten naar riool"]
[null,null,null,null,null,null,null,"Invoer",null,null,null,null,null,"Noord",null,"Op welk dagdeel heeft u zon op uw dak?",null,null,null,"De richting van uw dak","Zie https://www.vastelastenbond.nl/zonnepanelen/calculator/"]
[null,null,null,null,"How much surface area will be used for renewable energy production?",null,null,0,"m²"]
[null,null,null,null,"Assumption: m² per solar panel",null,null,2.5,"m²"]
[null,null,null,null,"This sums up to: ...  Panels",null,null,{"$f":"H91/H92*Q113","v":0},"panels"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(default waarde instellen)"]
[null,null,null,null,"Investment costs",null,null,470,"per panel without taks",null,null,null,null,null,"4700 per 10 panelen",null,"https://www.zonnepanelen-weetjes.nl/prijzen-zonnepanelen/"]
[null,null,null,null,"Maintenance costs",null,null,{"$f":"H93*(3.5/5)","v":0},"per roof per year without taks",null,null,null,null,null,"onderhoud  100-150 euro",null,"https://www.zonnepanelen-weetjes.nl/zonnepanelen-kopen/onderhoud-zonnepanelen/#:~:text=Kosten%20onderhoud%20zonnepanelen&text=Wel%20is%20het%20verstandig%20om,%E2%82%AC%20100%20en%20%E2%82%AC%20150."]
[null,null,null,null,"Replacement period (after X years)",null,null,25,"year",null,null,null,null,null,"25 jaar garantie ",null,"https://www.zonneplan.nl/kenniscentrum/zonnepanelen/levensduur"]
[null,null,null,null,"Total investment costs",null,null,{"$f":"IFERROR(H95*H93,0)","v":0}]
[]
[null,null,null,null,"Rate per kWh ",null,null,0.22,null,null,null,null,null,null,"Default waarde op 0,23 cent per kWh"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Noord"]
[null,null,null,null,"Which type of roof do you have, please select one",null,null,null,null,null,null,null,null,"Oost",null,"rond het middaguur in de zon",null,null,null,"Zuid of Zuid/Oost of Zuid/West"]
[null,null,null,null,"The shape of your roof has a large impact on the efficiency an the number of solar panels on your roof.",null,null,null,null,null,null,null,null,"Zuidoost",null,"in de namiddag/avond in de zon",null,null,null,"Zuid/West of West","Baten (koppelen aan aparte tabbladen per baat)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Zuid",null,"niet echt in de zon",null,null,null,"Noord of Noord/Oost of Noord/West","Energieopbrengst: terugleveren voor 0,09 cent per KWh en verdiscontering voor 0,23 cent per KWh (alles wat je niet teruglevert maar wel opwekt)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Zuidwest",null,null,null,null,null,null,"Luchtkwaliteit: vermeden uitstoot van NOx, SO2, VOS, fijnstoot, CO2 "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"West"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Noordwest"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flat roof",false,1]
[null,null,null,null,"The shape of your roof is….",null,null,{"$f":"IF(P109=TRUE,O109,IF(P110=TRUE,O110,IF(P111=TRUE,O111,IF(P112=TRUE,O112,\"\"))))","v":"Slightly angled roof"},null,null,null,null,null,null,"Slightly angled roof",true,0.8]
[null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(P109:P112,TRUE)>1,\"Kies één type dak\",\"\")","v":""},null,null,null,null,null,null,"Angled roof",false,0.6]
[null,null,null,null,"Total",null,null,null,null,null,null,null,null,null,"Very angled roof",false,0.4]
[null,null,null,null,"kWh energy per year",null,null,{"$f":"'Luchtkwaliteit en klimaat'!C29","v":0},"kWh per year",null,null,null,null,null,null,null,{"$f":"IF(P109=TRUE,Q109,IF(P110=TRUE,Q110,IF(P111=TRUE,Q111,IF(P112=TRUE,Q112,\"\"))))","v":0.8}]
[null,null,null,null,"Investment costs",null,null,{"$f":"MROUND(H98,100)","v":0},"without tax",null,null,null,null,null,null,{"$f":"IF(COUNTIF(P109:P112,TRUE)>1,\"Kies één type dak\",\"\")","v":""}]
[null,null,null,null,"Maintenance costs",null,null,{"$f":"MROUND(H96,100)","v":0},"without tax per year"]
[]
[]
[null,"Red roofs have a social function"]
[null,null,null,null,"Commercial activities",null,null,"Input"]
[null,null,null,null,"How much roof are you using for commercial activities?",null,null,null,"m²"]
[null,null,null,null,"What is the function of the roof?",null,null,"-","Choose a function"]
[null,null,null,null,"Earnings per visitor",null,null,null,"per visitor",null,null,null,null,null,null,null,null,null,null,null,"Sociale cohesie (kwalitatief)"]
[null,null,null,null,"Number of visitors per year",null,null,null,"per year",null,null,null,null,null,"Investering","Onderhoud","Uitgave per bezoeker",null,null,null,"Ontmoeting"]
[null,null,null,null,"Social activities",null,null,null,null,null,null,null,null,"Terrace/Bar",50,{"$f":"0.02*O124","v":1},10,null,null,null,"Recreatie"]
[null,null,null,null,"How much roof are you using for social activities?",null,null,0,"m²",null,null,null,null,"Restaurant",75,{"$f":"0.02*O125","v":1.5},30]
[null,null,null,null,"What is the function of the roof?",null,null,"Private terrace","Choose a function",null,null,null,null,"Attraction",30,0.6,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"-",0,0,0]
[null,null,null,null,"Investment costs",null,null,50,"per m² "]
[null,null,null,null,"Maintenance costs",null,null,10,"per m² per year",null,null,null,null,null,"(afhankelijk van functie, default waarde instellen)",null,null,null,null,null,"Private terrace"]
[null,null,null,null,"Replacement period (after X years)",null,null,30,"year",null,null,null,null,null,"(afhankelijk van functie, default waarde instellen)",null,null,null,null,null,"Meeting space"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Recreation"]
[null,null,null,null,"Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sports"]
[null,null,null,null,"Earnings per year",null,null,{"$f":"MROUND(H122*H123,100)","v":0},"per year",null,null,null,null,null,null,null,null,null,null,null,"None"]
[null,null,null,null,"Investment costs",null,null,{"$f":"H128*(H120+H125)","v":0},"without tax"]
[null,null,null,null,"Maintenance costs",null,null,{"$f":"H129*(H120+H125)","v":0},"without tax per year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"r (opbrengst), adv functies"]
[]
[null,"Orange roofs are used for transport and mobility."]
[null,null,null,null,null,null,null,"Invoer",null,null,null,null,null,null,"Nee",{"$f":"IF(H140=\"Ja\",IF(H141=\"Ja\",1,0),0)","v":0},null,null,null,null,"Baten (koppelen aan aparte tabbladen per baat)"]
[null,null,null,null,"Is your roof in connection with other roofs?",null,null,"Nee",null,null,null,null,null,"Indien ja dan door naar:",null,null,null,null,null,null,"Reistijdverkorting (kwalitatief)"]
[null,null,null,null,"Does travel time decrease because of transport and mobilityvia your roof?",null,null,"Nee",null,null,null,null,null,null,null,null,null,null,null,null,"Gezondheid: nodigt uit tot bewegen (kwalitatief)"]
[null,null,null,null,"Does the roof encourage exercise (running or other exercise)?",null,null,"Nee"]
[null,null,null,null,"How much of the roof will be used for transport and mobility?",null,null,0,"m²"]
[null,null,null,null,"Investment costs",null,null,null,"per m² ",null,null,null,null,"Default waarde"]
[null,null,null,null,"Maintenance costs",null,null,null,"per m² without tax",null,null,null,null,"Default waarde"]
[null,null,null,null,"Replacement period (after X years)",null,null,null,"year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Default waarde"]
[null,null,null,null,"Total"]
[null,null,null,null,"Investment costs",null,null,{"$f":"MROUND(H144*H143,100)","v":0},"without tax"]
[null,null,null,null,"Maintenance costs",null,null,{"$f":"MROUND(H145*H143,100)","v":0},"without tax per year"]
[]
[]
[]
[null,"Purple roofs consist of living space",null,null,null,null,null,null,null,null,null,null,null,"deze kleur is lelijk, kies voor allemaal iets moois"]
[null,null,null,null,null,null,null,"Input"]
[null,null,null,null,"How much living space are you adding",null,null,0,"m²"]
[null,null,null,null,"Investment costs",null,null,null,"per m² "]
[null,null,null,null,"Maintenance costs",null,null,null,"per m² "]
[]
[null,null,null,null,"Total"]
[null,null,null,null,"Investment costs",null,null,{"$f":"MROUND(H156*H157,100)","v":0},"without tax"]
[null,null,null,null,"Maintenance costs",null,null,{"$f":"MROUND(H158*H156,100)","v":0},"without tax per year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(defaultwaarde per functie)"]
[null,"Grey roofs are for technical installations"]
[null,null,null,null,null,null,null,"Invoer"]
[null,null,null,null,"How much area is \"lost\" to technical installations?",null,null,null,"m²"]
[null,null,null,null,"Investment costs",null,null,null,"per m² "]
[null,null,null,null,"Maintenance costs",null,null,null,"per m² per year"]
[null,null,null,null,"Replacement period (after X years)",null,null,30,"year"]
[]
[]
[null,"Financial contributions of thrid parties"]
[null,null,null,null,null,null,null,"Invoer"]
[null,null,null,null,"Are subsidies available?",null,null,"Ja"]
[null,null,null,null,"Subsidy 1",null,null,0,"per m² "]
[null,null,null,null,"Surface area",null,null,0,"m²"]
[null,null,null,null,"Total subsidy 1",null,null,{"$f":"H178*H177","v":0}]
[null,null,null,null,"Subsidy 2",null,null,0,"per m² "]
[null,null,null,null,"Surface area",null,null,null,"m²"]
[null,null,null,null,"Total subsidy 2",null,null,{"$f":"H181*H180","v":0}]
[null,null,null,null,"Subsidy 3",null,null,0,"per m² "]
[null,null,null,null,"Surface area",null,null,null,"m²"]
[null,null,null,null,"Total subsidy 3",null,null,{"$f":"H184*H183","v":0}]
[]
[null,null,null,null,null,null,"Total:",{"$f":"MROUND(SUM(H185,H182,H179),100)","v":0}]
[]
[]
[null,"Economic principles"]
[null,null,null,null,null,null,null,"Input"]
[null,null,null,null,"Discount rate",null,null,2.2499999999999999E-2]
[null,null,null,null,"Period of analysis",null,null,40,"year"]

{"sheet":"3 Results","index":3,"n_rows":79,"n_cols":59,"rows_kept":79,"cut":false,"hidden":false,"merged":[[67,9,67,14],[53,26,54,26],[48,15,50,16],[48,8,50,8],[63,1,63,2],[55,1,56,2],[67,15,67,16],[51,15,52,16],[55,15,56,16],[57,15,58,16],[60,15,61,16],[65,15,66,16],[62,15,62,16],[63,15,63,16],[64,15,64,16],[65,9,66,14],[23,52,23,53],[39,13,39,14],[54,9,54,14],[59,9,59,14],[58,5,58,6],[57,5,57,6],[53,15,53,16],[54,15,54,16],[59,15,59,16],[55,9,56,14],[57,9,58,14],[55,8,56,8],[55,5,55,6],[47,8,47,11],[47,19,47,24],[47,4,47,6],[65,8,66,8],[60,8,61,8],[57,8,58,8],[63,9,63,14],[64,9,64,14],[60,9,61,14],[62,9,62,14],[64,1,64,3],[47,1,47,2],[48,20,48,25],[53,20,55,25],[52,20,52,25],[51,20,51,25],[53,19,55,19],[50,20,50,25],[49,20,49,25],[54,1,54,2],[48,9,50,14],[51,9,52,14],[51,8,52,8],[53,9,53,14],[47,15,47,16]]}
[]
[]
[null,"Project",null,null,null,null,null,null,null,"Results",null,null,null,null,null,null,null,null,null,null,"Multifunctional roof as part of a greater construction project",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aandeel investering multifunctioneel dak in totale investering",{"$f":"IFERROR(G13/'1 Current state of the building'!F34*100%,0)","v":0}]
[null,"Project name",{"$f":"'1 Current state of the building'!O7","v":0},null,null,"Type of Neighbourhood",{"$f":"'1 Current state of the building'!F22","v":"Hoogbouw"},null,null,"On this sheet, you will find the results of your calculations. The results are divided into three parts:",null,null,null,null,null,null,null,null,null,null,{"$f":"\"The investment costs of the multifunctional roof are \" & ROUND(AT3,2)*100 & \"% of the total construction costs\"","v":"The investment costs of the multifunctional roof are 0% of the total construction costs"}]
[null,"Version",{"$f":"'1 Current state of the building'!F8","v":0},null,null,null,null,null,null,"1. The financial businesscase.",null,null,null,null,null,null,null,null,null,null,"Investment costs multifunctional roof:",null,null,{"$f":"IFERROR(MROUND(G13,100),\"\")","v":0},"without tax"]
[null,"Date",{"$f":"'1 Current state of the building'!O9","v":"2021-06-02"},null,null,null,null,null,null,"2. The social cost-benefit analysis",null,null,null,null,null,null,null,null,null,null,"Investment costs total construction project:",null,null,{"$f":"'1 Current state of the building'!F34","v":0},"without tax"]
[null,"Variant",{"$f":"'1 Current state of the building'!O7","v":0},null,null,null,null,null,null,"3. The social benefits further elaborated upon."]
[]
[null,"1. Results of the financial businesscase.",null,null,null,{"$f":"\"Period of analysis: \" &'2 Design of the roof'!H193 & \" year\"","v":"Period of analysis: 40 year"}]
[null,null,"Balance of costs and benefits",null,null,null,null,null,null,"Yearly costs and benefits",null,null,null,null,null,null,null,null,null,null,"Investment costs for each type of roof"]
[]
[null,null,null,null,null,null,{"$f":"MROUND(BE36,1000)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(MROUND(BA39,100),0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"Q32","v":0}]
[null,null,null,null,null,null,{"$f":"BF36","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(BA40,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"Q33","v":0}]
[null,null,null,null,null,null,{"$f":"BG36","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(BA41,0)","v":0},null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q12:Q14)","v":0},null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q36","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q38","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"\"2. Results of the social cost-benefit analysis, Period of analysis: \" &'2 Design of the roof'!H193 & \" year\"","v":"2. Results of the social cost-benefit analysis, Period of analysis: 40 year"}]
[null,null,"Balance of the social costs and benefits",null,null,null,null,null,"Costs for each type of roof",null,null,null,null,null,null,null,null,null,null,null,"Yearly social benefits"]
[null,null,null,null,null,null,{"$f":"MROUND(BE33,1000)","v":0},null,null,null,null,null,null,"Investering per dakfunctie",null,null,null,null,null,null,null,null,null,null,"Baten per dakfunctie",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4155,77]
[null,null,null,null,null,null,{"$f":"BF33","v":0},null,null,null,null,null,null,"% van totale investering project",null,null,null,null,null,null,null,null,null,null,"Water collection and storage (Blue roof)",{"$f":"IFERROR(AA31/$AA$40,\"\")","v":""},{"$f":"IFERROR('NCW MKBA'!F9,0)","v":0},"per year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BA30/365","v":11.383561643835616},{"$f":"BB30/365","v":0.21095890410958903},null,null,"MKBA"]
[null,null,null,null,null,null,{"$f":"G30-G31","v":0},null,null,null,null,null,null,"Blue roof",null,{"$f":"IFERROR(Q32/$Q$40,\"\")","v":""},{"$f":"'NCW Financieel'!M6","v":0},null,null,null,null,null,null,null,"Renewable energy (Yellow roof)",{"$f":"IFERROR(AA32/$AA$40,\"\")","v":""},{"$f":"IFERROR('NCW MKBA'!G9,0)","v":0},"per year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Beneftis","Costs","Balance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yellow roof",null,"",{"$f":"MROUND('NCW Financieel'!N6,1000)","v":0},null,null,null,null,null,null,null,"Avoided CO2 emissions (yellow roof)","",{"$f":"IFERROR('NCW MKBA'!H9,0)","v":0},"per year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,225,"kWh per paneel",null,null,{"$f":"IFERROR('NCW MKBA'!E78,0)","v":0},{"$f":"'NCW MKBA'!E77","v":0},{"$f":"BE33-BF33","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Green roof",null,"",{"$f":"'NCW Financieel'!L6","v":0},null,null,null,null,null,null,null,"Avoided emissions (Yellow roof)","",{"$f":"IFERROR('NCW MKBA'!H9,0)","v":0},"per year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Financiële businesscase"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Purple roof",null,"",{"$f":"'NCW Financieel'!Q6","v":0},null,null,null,null,null,null,null,"Fine dust particles captured (green roof)","",{"$f":"IFERROR('NCW MKBA'!K9,0)","v":0},"per year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Beneftis","Costs","Balance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Red roof",null,"",{"$f":"'NCW Financieel'!O6","v":0},null,null,null,null,null,null,null,"Avoided healthcare expenses (green roof)","",{"$f":"IFERROR('NCW MKBA'!L9,0)","v":0},"per year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR('NCW Financieel'!E6,0)","v":0},{"$f":"IFERROR('NCW Financieel'!E80,0)","v":0},{"$f":"BE36-BF36","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Grey roof",null,"",{"$f":"'NCW Financieel'!R6","v":0},null,null,null,null,null,null,null,"Avoided loss of work (green roof)","",{"$f":"IFERROR('NCW MKBA'!M9,0)","v":0},"per year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Oranje roof",null,"",{"$f":"'NCW Financieel'!P6","v":0},null,null,null,null,null,null,null,"Commercial activities (red roof)",null,{"$f":"'NCW Financieel'!F9","v":0},"per year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yellow roof",{"$f":"IFERROR('NCW Financieel'!G10+'NCW Financieel'!H10,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Totale Investering:",null,1,{"$f":"MROUND(SUM(Q32:Q39),100)","v":0},null,null,null,null,null,null,null,"Totale baten:",1,{"$f":"MROUND(SUM(AA31:AA37),100)","v":0},"per year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maintenance costs",{"$f":"IFERROR('NCW Financieel'!U9*-1,0)","v":0},null,null,"Baten"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Red roof",{"$f":"IFERROR('NCW Financieel'!F9,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Balance",{"$f":"SUM(BA39:BA41)","v":0},null,null,"Kosten"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Saldo"]
[]
[]
[null,"3. The social benefits further elaborated upon."]
[null,"Blue roof: Water retention",null,null,"Other social benefits (qualitative)",null,null,null,"Contribution to BREEAM credits*",null,null,null,null,null,null,"Applicable?",null,null,null,"Contribution to biodiversity acoording to the nature point system**",null,null,null,null,null,null,"Applicable"]
[null,"Number of filled waterbarrels",null,null,{"$f":"'2 Design of the roof'!H156","v":0},"Living area",null,null,"SYN 5","Encouraging the administrative and/or financial participation of the users in the area to increase involvement and responsibility of the area.",null,null,null,null,null,{"$f":"IF('3 Results'!X5>1,\"Yes\",\"No\")","v":"No"},null,null,null,1,"Green roof with sedum (>5-7cm)/30%",null,null,null,null,null,{"$f":"IF('2 Design of the roof'!H62>0, \"Yes\",\"No\")","v":"No"}]
[null,null,null,null,{"$f":"'2 Design of the roof'!P139","v":0},"Mobility",null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Green roof with sedum, grass, and herbs (>7-15cm)/30%",null,null,null,null,null,{"$f":"IF('2 Design of the roof'!E41>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,{"$f":"'2 Design of the roof'!H22","v":0},"Heatstress",null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Green roof with (sedum), grass and herbs, dwarf shrubs and shrubs (15-30 cm)/30%",null,null,null,null,null,{"$f":"IF('2 Design of the roof'!E41>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,{"$f":"'2 Design of the roof'!H22","v":0},"Image owner",null,null,"SYN 6","Encouraging cooperation and financial arrangements between stakeholders to increase the feasibility of the sustainability goals.",null,null,null,null,null,{"$f":"IF('3 Results'!X5>1,\"Yes\",\"No\")","v":"No"},null,null,null,4,"Green roof with (grass), herbs, dwarf shrubs and shrubs (30-50 cm)/30%",null,null,null,null,null,{"$f":"IF('2 Design of the roof'!E41>0,\"Yes\",\"No\")","v":"No"}]
[null,{"$f":"'2 Design of the roof'!H72*'2 Design of the roof'!H73/1000/0.1","v":0},null,null,{"$f":"'2 Design of the roof'!H22","v":0},"Business climate",null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Green roof with herbs, dwarf shrubs, shrubs, and trees (>50 cm) /30%",null,null,null,null,null,{"$f":"IF('2 Design of the roof'!E52>0,\"Yes\",\"No\")","v":"No"}]
[null,{"$f":"IF('2 Design of the roof'!H78=\"Ja\",\"This water is reused for:\"&'2 Design of the roof'!H81,\"\")","v":""},null,null,{"$f":"'2 Design of the roof'!H125","v":0},"Social cohesion",null,null,"BRO 3","Boosting local renewable energy production",null,null,null,null,null,{"$f":"IF('2 Design of the roof'!H113>1,\"Yes\",\"No\")","v":"No"},null,null,null,6,"Only for high-rise buildings (> 50m): at least 100% of the footprint of the urban layer is returned as horizontal outdoor spaces such as roof gardens. At least 40% of this must be designed with greenery that contributes to biodiversity",null,null,null,null,null,"Yes"]
[null,"Yellow roof: renewable energy",null,null,{"$f":"'2 Design of the roof'!H72","v":0},"Waterquality",null,null,"BRO 4","Reducing the use of drinking water in the area",null,null,null,null,null,{"$f":"IF('2 Design of the roof'!H78=\"Ja\",\"Yes\",\"No\")","v":"No"}]
[null,"Equivalent number of household",null,null,null,null,null,null,"RO 7","Preserving and increasing biodiversity and the ecological value and function on local and regional level.",null,null,null,null,null,{"$f":"IF('2 Design of the roof'!H62>0,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of nature points earned",null,{"$f":"COUNTIF(AA49:AA55,\"*Ja*\")","v":0}]
[null,null,null,null,null,null,null,null,"RO 8","Encouraging intensive use of space to minimise land use of the built environment.",null,null,null,null,null,{"$f":"IF('1 Current state of the building'!F31>1,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Disclaimer: the use of the nature point system is indicative. No rights can be derived from this"]
[null,null,null,null,null,null,null,null,"RO 11","Minimizing flood risk in the area after development",null,null,null,null,null,{"$f":"IF('2 Design of the roof'!H72>1,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,"RO 12","Preventing damage tot the built environment and vital and vulnerable functions due to extreme precipatation",null,null,null,null,null,{"$f":"IF('2 Design of the roof'!H72>1,\"Yes\",\"No\")","v":"No"}]
[null,{"$f":"'2 Design of the roof'!H93*'3 Results'!BA33/BA30","v":0}]
[null,null,null,null,null,null,null,null,"RO 13","Stimulating an optimal system for the use of people and transport needs (products) of an area and its environment with the lowest possible environmental impact.",null,null,null,null,null,{"$f":"IF('2 Design of the roof'!H143>1,\"Yes\",\"No\")","v":"No"}]
[null,{"$f":"\"Red roof: commercial activities of the: \"&'2 Design of the roof'!H121&\"\"","v":"Red roof: commercial activities of the: -"},null,null,null,null,null,null,"WEL 2","Promoting social cohesion in the area",null,null,null,null,null,{"$f":"IF('2 Design of the roof'!H125>1,\"Yes\",\"No\")","v":"No"}]
[null,"Benefits (x € 1.000)",null,null,null,null,null,null,"WEL 3","Improving the quality of the environmental experience",null,null,null,null,null,{"$f":"IF('2 Design of the roof'!H22>1,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,"KLI 1","Stimulating a good thermal outdoor climate for users and preventing heat stress",null,null,null,null,null,{"$f":"IF('2 Design of the roof'!H22>1,\"Yes\",\"No\")","v":"No"}]
[]
[null,null,null,null,null,null,null,null,"KLI 3","Optimizing local air quality.",null,null,null,null,null,{"$f":"IF('2 Design of the roof'!H22>1,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total:",{"$f":"COUNTIF(P49:P68,\"*Ja*\")","v":0},{"$f":"COUNTIF(I100:J112,\"Ja\")","v":0}]
[null,null,null,null,null,null,null,null,"Disclaimer: the use of this table is indicative. No rights can be derived"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]

{"sheet":"What's next","index":4,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Next steps"]
[]
[null,1,"Print the summary and results of your SCBA",null,"Client"]
[]
[]
[null,2,"Select this button to save your report"]
[]
[null,null,null,null,"Partners"]
[null,3,"‘Are you wondering how to continue from this point on, please follow the links below for additional information’. "]
[]
[]
[]
[]
[null,null,null,null,"Part of"]
[]
[]
[]
[]
[]
[null,null,null,null,"LIFE-projectnumber: LIFE16CCA/NL/000096"]

{"sheet":"NCW Financieel","index":5,"n_rows":82,"n_cols":32,"rows_kept":82,"cut":false,"hidden":true,"merged":[[4,0,4,1],[6,26,6,31]]}
[]
["NCW BEREKENING: Financiele Business Case"]
[null,null,null,"TOTAAL","Opbrengsten",null,null,null,null,null,"KOSTEN"]
[]
["Ncw per 1-1-2021",null,null,"Totaal","Subtotaal","Opbrengsten exploitatie rood dak","Energie opbrengsten teruglevering","Energiebesparing verbruik","Waterhergebruik","Subsidie","Subtotaal","Groen","Blauw","Geel","Rood","Oranje","Paars ","Grijs","Investeringskosten","Investeringskosten regulier dak (negatief)","Beheer- en onderhoud"]
[null,null,null,{"$f":"NPV($B$9,D$10:D$49)","v":0},{"$f":"SUM($E$10:INDEX(E$10:E$69,MATCH($Y$7,A10:A69,0)))","v":0},{"$f":"NPV($B$9,F$10:INDEX(F$10:F$69,MATCH($Y$7,$A10:$A69,0)))","v":0},{"$f":"NPV($B$9,G$10:INDEX(G$10:G$69,MATCH($Y$7,$A10:$A69,0)))","v":0},{"$f":"NPV($B$9,H$10:INDEX(H$10:H$69,MATCH($Y$7,$A10:$A69,0)))","v":0},{"$f":"NPV($B$9,I$10:INDEX(I$10:I$69,MATCH($Y$7,$A10:$A69,0)))","v":0},{"$f":"NPV($B$9,J$10:INDEX(J$10:J$69,MATCH($Y$7,$A10:$A69,0)))","v":0},{"$f":"NPV($B$9,K$10:INDEX(K$10:K$69,MATCH($Y$7,$A10:$A69,0)))","v":0},{"$f":"NPV($B$9,L$10:INDEX(L$10:L$69,MATCH($Y$7,$A10:$A69,0)))","v":0},{"$f":"NPV($B$9,M$10:INDEX(M$10:M$69,MATCH($Y$7,$A10:$A69,0)))","v":0},{"$f":"NPV($B$9,N$10:INDEX(N$10:N$69,MATCH($Y$7,$A10:$A69,0)))","v":0},{"$f":"NPV($B$9,O$10:INDEX(O$10:O$69,MATCH($Y$7,$A10:$A69,0)))","v":0},{"$f":"NPV($B$9,P$10:INDEX(P$10:P$69,MATCH($Y$7,$A10:$A69,0)))","v":0},{"$f":"NPV($B$9,Q$10:INDEX(Q$10:Q$69,MATCH($Y$7,$A10:$A69,0)))","v":0},{"$f":"NPV($B$9,R$10:INDEX(R$10:R$69,MATCH($Y$7,$A10:$A69,0)))","v":0},{"$f":"NPV($B$9,S$10:INDEX(S$10:S$69,MATCH($Y$7,$A10:$A69,0)))","v":0},{"$f":"NPV($B$9,T$10:INDEX(T$10:T$69,MATCH($Y$7,$A10:$A69,0)))","v":0},{"$f":"NPV($B$9,U$10:INDEX(U$10:U$69,MATCH($Y$7,$A10:$A69,0)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S6:U6)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'2 Design of the roof'!H193","v":40},null,"Vervangingstermijnen"]
[null,"Normaal","CO2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,null,"Groen","Waterberging","Geel","Rood","Paars","Grijs"]
["Discontofactor",{"$f":"'2 Design of the roof'!H192","v":2.2499999999999999E-2},2.9000000000000001E-2,null,null,{"$f":"IF('2 Design of the roof'!H120>0,('2 Design of the roof'!$H$123*'2 Design of the roof'!$H$122),0)","v":0},{"$f":"IF('Luchtkwaliteit en klimaat'!C29>'1 Current state of the building'!F21,('Luchtkwaliteit en klimaat'!C29-'1 Current state of the building'!F21)*'Luchtkwaliteit en klimaat'!C33,0)","v":0},{"$f":"'Luchtkwaliteit en klimaat'!$E$36-G9","v":0},{"$f":"Waterretentie!C14","v":0},{"$f":"'2 Design of the roof'!H187","v":0},null,{"$f":"'2 Design of the roof'!H63","v":0},{"$f":"'2 Design of the roof'!H85","v":0},{"$f":"'2 Design of the roof'!H98","v":0},{"$f":"'2 Design of the roof'!H134","v":0},{"$f":"'2 Design of the roof'!H149","v":0},{"$f":"'2 Design of the roof'!H161","v":0},{"$f":"'2 Design of the roof'!H169","v":0},{"$f":"SUM(L9:R9)","v":0},{"$f":"-1*'1 Current state of the building'!F15*('2 Design of the roof'!H22+('2 Design of the roof'!H72)+'2 Design of the roof'!H120+'2 Design of the roof'!H125+'2 Design of the roof'!H143+'2 Design of the roof'!H156)","v":0},{"$f":"('2 Design of the roof'!H162+'2 Design of the roof'!H150+'2 Design of the roof'!H135+'2 Design of the roof'!H115+'2 Design of the roof'!H86+'2 Design of the roof'!H64)","v":0},{"$f":"SUM('2 Design of the roof'!H98+'2 Design of the roof'!H85+'2 Design of the roof'!F136+'2 Design of the roof'!H63+'2 Design of the roof'!H157)","v":0},null,20,null,null,{"$f":"'2 Design of the roof'!H33","v":60},{"$f":"'2 Design of the roof'!H74","v":30},{"$f":"'2 Design of the roof'!H97","v":25},{"$f":"'2 Design of the roof'!H130","v":30},30,{"$f":"'2 Design of the roof'!H171","v":30}]
[1,{"$f":"1/(1+$B$9)^A10","v":0.97799511002444994},{"$f":"1/(1+$C$9)^A10","v":0.97181729834791064},{"$f":"E10-K10","v":0},{"$f":"SUM(F10:I10)+J6","v":0},{"$f":"F$9","v":0},{"$f":"G$9","v":0},{"$f":"H$9","v":0},{"$f":"I$9","v":0},{"$f":"J9","v":0},{"$f":"SUM(S10:U10)","v":0},{"$f":"L9","v":0},{"$f":"M9","v":0},{"$f":"N9","v":0},{"$f":"O9","v":0},0,0,0,{"$f":"SUM(L10:R10)","v":0},{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A10-0),'NCW Financieel'!$T$9,0)","v":0},0,null,null,30,null,null,{"$f":"INT($A10/AA$9)=($A10/AA$9)","v":false},{"$f":"INT($A10/AB$9)=($A10/AB$9)","v":false},false,false,false,false]
[2,0.95647443523173592,{"$f":"1/(1+$C$9)^A11","v":0.9444288613682319},{"$f":"E11-K11","v":0},{"$f":"SUM(F11:I11)","v":0},{"$f":"F$9","v":0},{"$f":"G$9","v":0},{"$f":"H$9","v":0},0,null,0,{"$f":"_xlfn.IFS($Y$7=$A11,0,AA11=TRUE,L$9,AA11=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A11,0,AB11=TRUE,M$9,AB11=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A11,0,AC11=TRUE,N$9,AC11=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A11,0,AD11=TRUE,O$9,AD11=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A11,0,AE11=TRUE,P$9,AE11=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A11,0,AF11=TRUE,Q$9,AF11=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A11,0,AG11=TRUE,R$9,AG11=FALSE,0)","v":0},{"$f":"SUM(L11:R11)","v":0},{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A11-0),'NCW Financieel'!$T$9,0)","v":0},{"$f":"$U$9","v":0},null,null,40,null,null,{"$f":"INT($A11/AA$9)=($A11/AA$9)","v":false},false,false,false,false,false]
[3,0.93542732052003519,0.91781230453666862,0,{"$f":"SUM(F12:I12)","v":0},0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A12,0,AA12=TRUE,L$9,AA12=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A12,0,AB12=TRUE,M$9,AB12=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A12,0,AC12=TRUE,N$9,AC12=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A12,0,AD12=TRUE,O$9,AD12=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A12,0,AE12=TRUE,P$9,AE12=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A12,0,AF12=TRUE,Q$9,AF12=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A12,0,AG12=TRUE,R$9,AG12=FALSE,0)","v":0},{"$f":"SUM(L12:R12)","v":0},{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A12-0),'NCW Financieel'!$T$9,0)","v":0},{"$f":"$U$9","v":0},null,null,null,null,null,false,false,false,false,false,false]
[4,0.91484334525186817,0.89194587418529503,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A13,0,AA13=TRUE,L$9,AA13=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A13,0,AB13=TRUE,M$9,AB13=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A13,0,AC13=TRUE,N$9,AC13=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A13,0,AD13=TRUE,O$9,AD13=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A13,0,AE13=TRUE,P$9,AE13=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A13,0,AF13=TRUE,Q$9,AF13=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A13,0,AG13=TRUE,R$9,AG13=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A13-0),'NCW Financieel'!$T$9,0)","v":0},0,null,null,null,null,null,false,false,false,false,false,false]
[5,0.89471231809473661,0.86680842972331895,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A14,0,AA14=TRUE,L$9,AA14=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A14,0,AB14=TRUE,M$9,AB14=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A14,0,AC14=TRUE,N$9,AC14=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A14,0,AD14=TRUE,O$9,AD14=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A14,0,AE14=TRUE,P$9,AE14=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A14,0,AF14=TRUE,Q$9,AF14=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A14,0,AG14=TRUE,R$9,AG14=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A14-0),'NCW Financieel'!$T$9,0)","v":0},0,null,null,null,null,null,false,false,false,false,false,false]
[6,0.87502427197529253,0.8423794263589105,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A15,0,AA15=TRUE,L$9,AA15=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A15,0,AB15=TRUE,M$9,AB15=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A15,0,AC15=TRUE,N$9,AC15=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A15,0,AD15=TRUE,O$9,AD15=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A15,0,AE15=TRUE,P$9,AE15=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A15,0,AF15=TRUE,Q$9,AF15=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A15,0,AG15=TRUE,R$9,AG15=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A15-0),'NCW Financieel'!$T$9,0)","v":0},0,null,null,null,null,null,false,false,false,false,false,false]
[7,0.8557694591445405,0.81863889830797909,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A16,0,AA16=TRUE,L$9,AA16=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A16,0,AB16=TRUE,M$9,AB16=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A16,0,AC16=TRUE,N$9,AC16=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A16,0,AD16=TRUE,O$9,AD16=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A16,0,AE16=TRUE,P$9,AE16=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A16,0,AF16=TRUE,Q$9,AF16=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A16,0,AG16=TRUE,R$9,AG16=FALSE,0)","v":0},{"$f":"SUM(L16:R16)","v":0},{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A16-0),'NCW Financieel'!$T$9,0)","v":0},0,null,null,null,null,null,false,false,false,false,false,false]
[8,0.836938346351629,0.79556744247617017,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A17,0,AA17=TRUE,L$9,AA17=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A17,0,AB17=TRUE,M$9,AB17=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A17,0,AC17=TRUE,N$9,AC17=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A17,0,AD17=TRUE,O$9,AD17=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A17,0,AE17=TRUE,P$9,AE17=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A17,0,AF17=TRUE,Q$9,AF17=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A17,0,AG17=TRUE,R$9,AG17=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A17-0),'NCW Financieel'!$T$9,0)","v":0},0,null,null,null,null,null,false,false,false,false,false,false]
[9,0.81852161012384261,0.77314620260074862,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A18,0,AA18=TRUE,L$9,AA18=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A18,0,AB18=TRUE,M$9,AB18=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A18,0,AC18=TRUE,N$9,AC18=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A18,0,AD18=TRUE,O$9,AD18=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A18,0,AE18=TRUE,P$9,AE18=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A18,0,AF18=TRUE,Q$9,AF18=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A18,0,AG18=TRUE,R$9,AG18=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A18-0),'NCW Financieel'!$T$9,0)","v":0},0,null,null,null,null,null,false,false,false,false,false,false]
[10,0.8005101321504573,0.75135685383940576,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A19,0,AA19=TRUE,L$9,AA19=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A19,0,AB19=TRUE,M$9,AB19=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A19,0,AC19=TRUE,N$9,AC19=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A19,0,AD19=TRUE,O$9,AD19=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A19,0,AE19=TRUE,P$9,AE19=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A19,0,AF19=TRUE,Q$9,AF19=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A19,0,AG19=TRUE,R$9,AG19=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A19-0),'NCW Financieel'!$T$9,0)","v":0},0,null,null,null,null,null,false,false,false,false,false,false]
[11,0.78289499476817348,0.73018158779339737,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A20,0,AA20=TRUE,L$9,AA20=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A20,0,AB20=TRUE,M$9,AB20=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A20,0,AC20=TRUE,N$9,AC20=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A20,0,AD20=TRUE,O$9,AD20=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A20,0,AE20=TRUE,P$9,AE20=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A20,0,AF20=TRUE,Q$9,AF20=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A20,0,AG20=TRUE,R$9,AG20=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A20-0),'NCW Financieel'!$T$9,0)","v":0},0,null,null,null,null,null,false,false,false,false,false,false]
[12,0.76566747654589096,0.7096030979527671,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A21,0,AA21=TRUE,L$9,AA21=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A21,0,AB21=TRUE,M$9,AB21=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A21,0,AC21=TRUE,N$9,AC21=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A21,0,AD21=TRUE,O$9,AD21=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A21,0,AE21=TRUE,P$9,AE21=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A21,0,AF21=TRUE,Q$9,AF21=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A21,0,AG21=TRUE,R$9,AG21=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A21-0),'NCW Financieel'!$T$9,0)","v":0},0,null,null,null,null,null,false,false,false,false,false,false]
[13,0.74881904796664145,0.68960456555176597,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A22,0,AA22=TRUE,L$9,AA22=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A22,0,AB22=TRUE,M$9,AB22=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A22,0,AC22=TRUE,N$9,AC22=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A22,0,AD22=TRUE,O$9,AD22=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A22,0,AE22=TRUE,P$9,AE22=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A22,0,AF22=TRUE,Q$9,AF22=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A22,0,AG22=TRUE,R$9,AG22=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A22-0),'NCW Financieel'!$T$9,0)","v":0},0,null,null,null,null,null,false,false,false,false,false,false]
[14,0.73234136720453935,0.67016964582290184,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A23,0,AA23=TRUE,L$9,AA23=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A23,0,AB23=TRUE,M$9,AB23=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A23,0,AC23=TRUE,N$9,AC23=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A23,0,AD23=TRUE,O$9,AD23=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A23,0,AE23=TRUE,P$9,AE23=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A23,0,AF23=TRUE,Q$9,AF23=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A23,0,AG23=TRUE,R$9,AG23=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A23-0),'NCW Financieel'!$T$9,0)","v":0},0,null,null,null,null,null,false,false,false,false,false,false]
[15,0.7162262759946596,0.65128245463838852,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A24,0,AA24=TRUE,L$9,AA24=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A24,0,AB24=TRUE,M$9,AB24=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A24,0,AC24=TRUE,N$9,AC24=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A24,0,AD24=TRUE,O$9,AD24=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A24,0,AE24=TRUE,P$9,AE24=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A24,0,AF24=TRUE,Q$9,AF24=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A24,0,AG24=TRUE,R$9,AG24=FALSE,0)","v":0},{"$f":"SUM(L24:R24)","v":0},{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A24-0),'NCW Financieel'!$T$9,0)","v":0},0,null,null,null,null,null,false,false,false,false,false,false]
[16,0.70046579559379929,0.63292755552807445,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A25,0,AA25=TRUE,L$9,AA25=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A25,0,AB25=TRUE,M$9,AB25=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A25,0,AC25=TRUE,N$9,AC25=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A25,0,AD25=TRUE,O$9,AD25=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A25,0,AE25=TRUE,P$9,AE25=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A25,0,AF25=TRUE,Q$9,AF25=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A25,0,AG25=TRUE,R$9,AG25=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A25-0),'NCW Financieel'!$T$9,0)","v":0},0,null,null,null,null,null,false,false,false,false,false,false]
[17,0.68505212283012151,0.61508994706324049,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A26,0,AA26=TRUE,L$9,AA26=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A26,0,AB26=TRUE,M$9,AB26=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A26,0,AC26=TRUE,N$9,AC26=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A26,0,AD26=TRUE,O$9,AD26=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A26,0,AE26=TRUE,P$9,AE26=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A26,0,AF26=TRUE,Q$9,AF26=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A26,0,AG26=TRUE,R$9,AG26=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A26-0),'NCW Financieel'!$T$9,0)","v":0},0,null,null,null,null,null,false,false,false,false,false,false]
[18,0.66997762623972779,0.59775505059595779,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A27,0,AA27=TRUE,L$9,AA27=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A27,0,AB27=TRUE,M$9,AB27=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A27,0,AC27=TRUE,N$9,AC27=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A27,0,AD27=TRUE,O$9,AD27=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A27,0,AE27=TRUE,P$9,AE27=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A27,0,AF27=TRUE,Q$9,AF27=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A27,0,AG27=TRUE,R$9,AG27=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A27-0),'NCW Financieel'!$T$9,0)","v":0},0,null,null,null,null,null,false,false,false,false,false,false]
[19,0.65523484228824225,0.58090869834398229,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A28,0,AA28=TRUE,L$9,AA28=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A28,0,AB28=TRUE,M$9,AB28=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A28,0,AC28=TRUE,N$9,AC28=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A28,0,AD28=TRUE,O$9,AD28=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A28,0,AE28=TRUE,P$9,AE28=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A28,0,AF28=TRUE,Q$9,AF28=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A28,0,AG28=TRUE,R$9,AG28=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A28-0),'NCW Financieel'!$T$9,0)","v":0},0,null,null,null,null,null,false,false,false,false,false,false]
[20,0.64081647167554256,0.56453712181145022,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A29,0,AA29=TRUE,L$9,AA29=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A29,0,AB29=TRUE,M$9,AB29=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A29,0,AC29=TRUE,N$9,AC29=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A29,0,AD29=TRUE,O$9,AD29=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A29,0,AE29=TRUE,P$9,AE29=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A29,0,AF29=TRUE,Q$9,AF29=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A29,0,AG29=TRUE,R$9,AG29=FALSE,0)","v":0},{"$f":"SUM(L29:R29)","v":0},{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A29-0),'NCW Financieel'!$T$9,0)","v":0},0,null,null,null,null,null,false,false,{"$f":"INT($A29/AC$9)=($A29/AC$9)","v":false},false,false,false]
[21,0.62671537572180203,0.54862694053590888,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A30,0,AA30=TRUE,L$9,AA30=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A30,0,AB30=TRUE,M$9,AB30=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A30,0,AC30=TRUE,N$9,AC30=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A30,0,AD30=TRUE,O$9,AD30=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A30,0,AE30=TRUE,P$9,AE30=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A30,0,AF30=TRUE,Q$9,AF30=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A30,0,AG30=TRUE,R$9,AG30=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A30-0),'NCW Financieel'!$T$9,0)","v":0},0,null,null,null,null,null,false,false,false,false,false,false]
[22,0.61292457283305835,0.53316515115248686,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A31,0,AA31=TRUE,L$9,AA31=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A31,0,AB31=TRUE,M$9,AB31=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A31,0,AC31=TRUE,N$9,AC31=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A31,0,AD31=TRUE,O$9,AD31=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A31,0,AE31=TRUE,P$9,AE31=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A31,0,AF31=TRUE,Q$9,AF31=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A31,0,AG31=TRUE,R$9,AG31=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A31-0),'NCW Financieel'!$T$9,0)","v":0},0,null,null,null,null,null,false,false,false,false,false,false]
[23,0.59943723504455593,0.51813911676626512,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A32,0,AA32=TRUE,L$9,AA32=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A32,0,AB32=TRUE,M$9,AB32=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A32,0,AC32=TRUE,N$9,AC32=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A32,0,AD32=TRUE,O$9,AD32=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A32,0,AE32=TRUE,P$9,AE32=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A32,0,AF32=TRUE,Q$9,AF32=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A32,0,AG32=TRUE,R$9,AG32=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A32-0),'NCW Financieel'!$T$9,0)","v":0},0,null,null,null,null,null,false,false,false,false,false,false]
[24,0.5862466846401525,0.5035365566241643,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A33,0,AA33=TRUE,L$9,AA33=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A33,0,AB33=TRUE,M$9,AB33=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A33,0,AC33=TRUE,N$9,AC33=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A33,0,AD33=TRUE,O$9,AD33=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A33,0,AE33=TRUE,P$9,AE33=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A33,0,AF33=TRUE,Q$9,AF33=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A33,0,AG33=TRUE,R$9,AG33=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A33-0),'NCW Financieel'!$T$9,0)","v":0},0,null,null,null,null,null,false,false,false,false,false,false]
[25,0.57334639084611505,0.48934553607790515,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A34,0,AA34=TRUE,L$9,AA34=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A34,0,AB34=TRUE,M$9,AB34=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A34,0,AC34=TRUE,N$9,AC34=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A34,0,AD34=TRUE,O$9,AD34=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A34,0,AE34=TRUE,P$9,AE34=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A34,0,AF34=TRUE,Q$9,AF34=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A34,0,AG34=TRUE,R$9,AG34=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A34-0),'NCW Financieel'!$T$9,0)","v":0},0,null,null,null,null,null,false,false,true,false,false,false]
[26,0.5607299665976675,0.47555445682983971,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A35,0,AA35=TRUE,L$9,AA35=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A35,0,AB35=TRUE,M$9,AB35=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A35,0,AC35=TRUE,N$9,AC35=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A35,0,AD35=TRUE,O$9,AD35=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A35,0,AE35=TRUE,P$9,AE35=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A35,0,AF35=TRUE,Q$9,AF35=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A35,0,AG35=TRUE,R$9,AG35=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A35-0),'NCW Financieel'!$T$9,0)","v":0},0,null,null,null,null,null,false,false,false,false,false,false]
[27,0.54839116537669197,0.4621520474536831,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A36,0,AA36=TRUE,L$9,AA36=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A36,0,AB36=TRUE,M$9,AB36=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A36,0,AC36=TRUE,N$9,AC36=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A36,0,AD36=TRUE,O$9,AD36=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A36,0,AE36=TRUE,P$9,AE36=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A36,0,AF36=TRUE,Q$9,AF36=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A36,0,AG36=TRUE,R$9,AG36=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A36-0),'NCW Financieel'!$T$9,0)","v":0},0,null,null,null,null,null,false,false,false,false,false,false]
[28,0.53632387811901416,0.44912735418239363,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A37,0,AA37=TRUE,L$9,AA37=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A37,0,AB37=TRUE,M$9,AB37=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A37,0,AC37=TRUE,N$9,AC37=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A37,0,AD37=TRUE,O$9,AD37=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A37,0,AE37=TRUE,P$9,AE37=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A37,0,AF37=TRUE,Q$9,AF37=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A37,0,AG37=TRUE,R$9,AG37=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A37-0),'NCW Financieel'!$T$9,0)","v":0},0,null,null,null,null,null,false,false,false,false,false,false]
[29,0.52452213018974492,0.43646973195567895,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A38,0,AA38=TRUE,L$9,AA38=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A38,0,AB38=TRUE,M$9,AB38=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A38,0,AC38=TRUE,N$9,AC38=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A38,0,AD38=TRUE,O$9,AD38=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A38,0,AE38=TRUE,P$9,AE38=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A38,0,AF38=TRUE,Q$9,AF38=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A38,0,AG38=TRUE,R$9,AG38=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A38-0),'NCW Financieel'!$T$9,0)","v":0},0,null,null,null,null,null,false,false,false,false,false,false]
[30,0.51298007842517834,0.42416883571980463,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A39,0,AA39=TRUE,L$9,AA39=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A39,0,AB39=TRUE,M$9,AB39=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A39,0,AC39=TRUE,N$9,AC39=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A39,0,AD39=TRUE,O$9,AD39=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A39,0,AE39=TRUE,P$9,AE39=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A39,0,AF39=TRUE,Q$9,AF39=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A39,0,AG39=TRUE,R$9,AG39=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A39-0),'NCW Financieel'!$T$9,0)","v":0},0,null,null,null,null,null,false,true,false,true,true,true]
[31,0.50169200823978322,0.41221461197259929,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A40,0,AA40=TRUE,L$9,AA40=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A40,0,AB40=TRUE,M$9,AB40=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A40,0,AC40=TRUE,N$9,AC40=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A40,0,AD40=TRUE,O$9,AD40=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A40,0,AE40=TRUE,P$9,AE40=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A40,0,AF40=TRUE,Q$9,AF40=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A40,0,AG40=TRUE,R$9,AG40=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A40-0),'NCW Financieel'!$T$9,0)","v":0},0,null,null,null,null,null,false,false,false,false,false,false]
[32,0.49065233079685422,0.40059729054674376,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A41,0,AA41=TRUE,L$9,AA41=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A41,0,AB41=TRUE,M$9,AB41=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A41,0,AC41=TRUE,N$9,AC41=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A41,0,AD41=TRUE,O$9,AD41=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A41,0,AE41=TRUE,P$9,AE41=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A41,0,AF41=TRUE,Q$9,AF41=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A41,0,AG41=TRUE,R$9,AG41=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A41-0),'NCW Financieel'!$T$9,0)","v":0},0,null,null,null,null,null,false,false,false,false,false,false]
[33,{"$f":"1/(1+$B$9)^A42","v":0.47985558024142216},0.3893073766246295,0,0,0,0,0,0,null,{"$f":"SUM(S42:U42)","v":0},{"$f":"_xlfn.IFS($Y$7=$A42,0,AA42=TRUE,L$9,AA42=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A42,0,AB42=TRUE,M$9,AB42=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A42,0,AC42=TRUE,N$9,AC42=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A42,0,AD42=TRUE,O$9,AD42=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A42,0,AE42=TRUE,P$9,AE42=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A42,0,AF42=TRUE,Q$9,AF42=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A42,0,AG42=TRUE,R$9,AG42=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A42-0),'NCW Financieel'!$T$9,0)","v":0},0,null,null,null,null,null,false,false,false,false,false,false]
[34,0.469296410994056,0.37833564297825995,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A43,0,AA43=TRUE,L$9,AA43=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A43,0,AB43=TRUE,M$9,AB43=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A43,0,AC43=TRUE,N$9,AC43=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A43,0,AD43=TRUE,O$9,AD43=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A43,0,AE43=TRUE,P$9,AE43=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A43,0,AF43=TRUE,Q$9,AF43=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A43,0,AG43=TRUE,R$9,AG43=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A43-0),'NCW Financieel'!$T$9,0)","v":0},0,null,null,null,null,null,false,false,false,false,false,false]
[35,0.45896959510421126,0.36767312242785233,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A44,0,AA44=TRUE,L$9,AA44=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A44,0,AB44=TRUE,M$9,AB44=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A44,0,AC44=TRUE,N$9,AC44=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A44,0,AD44=TRUE,O$9,AD44=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A44,0,AE44=TRUE,P$9,AE44=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A44,0,AF44=TRUE,Q$9,AF44=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A44,0,AG44=TRUE,R$9,AG44=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A44-0),'NCW Financieel'!$T$9,0)","v":0},0,null,null,null,null,null,false,false,false,false,false,false]
[36,0.44887001966182033,0.35731110051297599,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A45,0,AA45=TRUE,L$9,AA45=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A45,0,AB45=TRUE,M$9,AB45=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A45,0,AC45=TRUE,N$9,AC45=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A45,0,AD45=TRUE,O$9,AD45=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A45,0,AE45=TRUE,P$9,AE45=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A45,0,AF45=TRUE,Q$9,AF45=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A45,0,AG45=TRUE,R$9,AG45=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A45-0),'NCW Financieel'!$T$9,0)","v":0},0,null,null,null,null,null,false,false,false,false,false,false]
[37,0.43899268426583893,0.34724110837023908,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A46,0,AA46=TRUE,L$9,AA46=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A46,0,AB46=TRUE,M$9,AB46=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A46,0,AC46=TRUE,N$9,AC46=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A46,0,AD46=TRUE,O$9,AD46=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A46,0,AE46=TRUE,P$9,AE46=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A46,0,AF46=TRUE,Q$9,AF46=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A46,0,AG46=TRUE,R$9,AG46=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A46-0),'NCW Financieel'!$T$9,0)","v":0},0,null,null,null,null,null,false,false,false,false,false,false]
[38,0.42933269854849776,0.33745491581169978,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A47,0,AA47=TRUE,L$9,AA47=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A47,0,AB47=TRUE,M$9,AB47=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A47,0,AC47=TRUE,N$9,AC47=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A47,0,AD47=TRUE,O$9,AD47=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A47,0,AE47=TRUE,P$9,AE47=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A47,0,AF47=TRUE,Q$9,AF47=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A47,0,AG47=TRUE,R$9,AG47=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A47-0),'NCW Financieel'!$T$9,0)","v":0},0,null,null,null,null,null,false,false,false,false,false,false]
[39,0.41988527975403206,0.32794452459834766,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A48,0,AA48=TRUE,L$9,AA48=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A48,0,AB48=TRUE,M$9,AB48=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A48,0,AC48=TRUE,N$9,AC48=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A48,0,AD48=TRUE,O$9,AD48=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A48,0,AE48=TRUE,P$9,AE48=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A48,0,AF48=TRUE,Q$9,AF48=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A48,0,AG48=TRUE,R$9,AG48=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A48-0),'NCW Financieel'!$T$9,0)","v":0},0,null,null,null,null,null,false,false,false,false,false,false]
[40,0.41064575037069156,0.3187021619031562,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A49,0,AA49=TRUE,L$9,AA49=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A49,0,AB49=TRUE,M$9,AB49=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A49,0,AC49=TRUE,N$9,AC49=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A49,0,AD49=TRUE,O$9,AD49=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A49,0,AE49=TRUE,P$9,AE49=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A49,0,AF49=TRUE,Q$9,AF49=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A49,0,AG49=TRUE,R$9,AG49=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A49-0),'NCW Financieel'!$T$9,0)","v":0},0,null,null,null,null,null,false,false,false,false,false,false]
[41,0.40160953581485731,0.30972027395836371,{"$f":"E50-K50","v":0},{"$f":"SUM(F50:I50)","v":0},0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A50,0,AA50=TRUE,L$9,AA50=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A50,0,AB50=TRUE,M$9,AB50=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A50,0,AC50=TRUE,N$9,AC50=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A50,0,AD50=TRUE,O$9,AD50=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A50,0,AE50=TRUE,P$9,AE50=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A50,0,AF50=TRUE,Q$9,AF50=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A50,0,AG50=TRUE,R$9,AG50=FALSE,0)","v":0},{"$f":"SUM(L50:R50)","v":0},{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A50-0),'NCW Financieel'!$T$9,0)","v":0},0]
[42,0.39277216216611965,0.30099151988179168,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A51,0,AA51=TRUE,L$9,AA51=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A51,0,AB51=TRUE,M$9,AB51=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A51,0,AC51=TRUE,N$9,AC51=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A51,0,AD51=TRUE,O$9,AD51=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A51,0,AE51=TRUE,P$9,AE51=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A51,0,AF51=TRUE,Q$9,AF51=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A51,0,AG51=TRUE,R$9,AG51=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A51-0),'NCW Financieel'!$T$9,0)","v":0},0]
[43,0.38412925395219527,0.29250876567715428,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A52,0,AA52=TRUE,L$9,AA52=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A52,0,AB52=TRUE,M$9,AB52=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A52,0,AC52=TRUE,N$9,AC52=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A52,0,AD52=TRUE,O$9,AD52=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A52,0,AE52=TRUE,P$9,AE52=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A52,0,AF52=TRUE,Q$9,AF52=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A52,0,AG52=TRUE,R$9,AG52=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A52-0),'NCW Financieel'!$T$9,0)","v":0},0]
[44,0.37567653198258705,0.28426507840345411,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A53,0,AA53=TRUE,L$9,AA53=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A53,0,AB53=TRUE,M$9,AB53=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A53,0,AC53=TRUE,N$9,AC53=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A53,0,AD53=TRUE,O$9,AD53=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A53,0,AE53=TRUE,P$9,AE53=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A53,0,AF53=TRUE,Q$9,AF53=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A53,0,AG53=TRUE,R$9,AG53=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A53-0),'NCW Financieel'!$T$9,0)","v":0},0]
[45,0.36740981122991401,0.27625372050870178,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A54,0,AA54=TRUE,L$9,AA54=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A54,0,AB54=TRUE,M$9,AB54=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A54,0,AC54=TRUE,N$9,AC54=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A54,0,AD54=TRUE,O$9,AD54=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A54,0,AE54=TRUE,P$9,AE54=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A54,0,AF54=TRUE,Q$9,AF54=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A54,0,AG54=TRUE,R$9,AG54=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A54-0),'NCW Financieel'!$T$9,0)","v":0},0]
[46,0.35932499875786211,0.26846814432332533,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A55,0,AA55=TRUE,L$9,AA55=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A55,0,AB55=TRUE,M$9,AB55=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A55,0,AC55=TRUE,N$9,AC55=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A55,0,AD55=TRUE,O$9,AD55=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A55,0,AE55=TRUE,P$9,AE55=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A55,0,AF55=TRUE,Q$9,AF55=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A55,0,AG55=TRUE,R$9,AG55=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A55-0),'NCW Financieel'!$T$9,0)","v":0},0]
[47,0.35141809169473071,0.26090198670877096,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A56,0,AA56=TRUE,L$9,AA56=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A56,0,AB56=TRUE,M$9,AB56=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A56,0,AC56=TRUE,N$9,AC56=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A56,0,AD56=TRUE,O$9,AD56=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A56,0,AE56=TRUE,P$9,AE56=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A56,0,AF56=TRUE,Q$9,AF56=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A56,0,AG56=TRUE,R$9,AG56=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A56-0),'NCW Financieel'!$T$9,0)","v":0},0]
[48,0.34368517525157044,0.25354906385692033,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A57,0,AA57=TRUE,L$9,AA57=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A57,0,AB57=TRUE,M$9,AB57=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A57,0,AC57=TRUE,N$9,AC57=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A57,0,AD57=TRUE,O$9,AD57=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A57,0,AE57=TRUE,P$9,AE57=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A57,0,AF57=TRUE,Q$9,AF57=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A57,0,AG57=TRUE,R$9,AG57=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A57-0),'NCW Financieel'!$T$9,0)","v":0},0]
[49,0.33612242078393195,0.2464033662360742,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A58,0,AA58=TRUE,L$9,AA58=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A58,0,AB58=TRUE,M$9,AB58=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A58,0,AC58=TRUE,N$9,AC58=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A58,0,AD58=TRUE,O$9,AD58=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A58,0,AE58=TRUE,P$9,AE58=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A58,0,AF58=TRUE,Q$9,AF58=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A58,0,AG58=TRUE,R$9,AG58=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A58-0),'NCW Financieel'!$T$9,0)","v":0},0]
[50,0.32872608389626606,0.23945905367937237,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A59,0,AA59=TRUE,L$9,AA59=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A59,0,AB59=TRUE,M$9,AB59=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A59,0,AC59=TRUE,N$9,AC59=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A59,0,AD59=TRUE,O$9,AD59=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A59,0,AE59=TRUE,P$9,AE59=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A59,0,AF59=TRUE,Q$9,AF59=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A59,0,AG59=TRUE,R$9,AG59=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A59-0),'NCW Financieel'!$T$9,0)","v":0},0]
[51,0.32149250258803524,0.23271045061163501,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A60,0,AA60=TRUE,L$9,AA60=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A60,0,AB60=TRUE,M$9,AB60=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A60,0,AC60=TRUE,N$9,AC60=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A60,0,AD60=TRUE,O$9,AD60=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A60,0,AE60=TRUE,P$9,AE60=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A60,0,AF60=TRUE,Q$9,AF60=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A60,0,AG60=TRUE,R$9,AG60=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A60-0),'NCW Financieel'!$T$9,0)","v":0},0]
[52,0.31441809544062127,0.22615204141072398,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A61,0,AA61=TRUE,L$9,AA61=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A61,0,AB61=TRUE,M$9,AB61=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A61,0,AC61=TRUE,N$9,AC61=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A61,0,AD61=TRUE,O$9,AD61=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A61,0,AE61=TRUE,P$9,AE61=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A61,0,AF61=TRUE,Q$9,AF61=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A61,0,AG61=TRUE,R$9,AG61=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A61-0),'NCW Financieel'!$T$9,0)","v":0},0]
[53,0.30749935984412835,0.2197784658996346,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A62,0,AA62=TRUE,L$9,AA62=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A62,0,AB62=TRUE,M$9,AB62=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A62,0,AC62=TRUE,N$9,AC62=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A62,0,AD62=TRUE,O$9,AD62=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A62,0,AE62=TRUE,P$9,AE62=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A62,0,AF62=TRUE,Q$9,AF62=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A62,0,AG62=TRUE,R$9,AG62=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A62-0),'NCW Financieel'!$T$9,0)","v":0},0]
[54,0.30073287026320628,0.2135845149656313,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A63,0,AA63=TRUE,L$9,AA63=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A63,0,AB63=TRUE,M$9,AB63=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A63,0,AC63=TRUE,N$9,AC63=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A63,0,AD63=TRUE,O$9,AD63=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A63,0,AE63=TRUE,P$9,AE63=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A63,0,AF63=TRUE,Q$9,AF63=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A63,0,AG63=TRUE,R$9,AG63=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A63-0),'NCW Financieel'!$T$9,0)","v":0},0]
[55,0.29411527654103309,0.20756512630284871,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A64,0,AA64=TRUE,L$9,AA64=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A64,0,AB64=TRUE,M$9,AB64=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A64,0,AC64=TRUE,N$9,AC64=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A64,0,AD64=TRUE,O$9,AD64=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A64,0,AE64=TRUE,P$9,AE64=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A64,0,AF64=TRUE,Q$9,AF64=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A64,0,AG64=TRUE,R$9,AG64=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A64-0),'NCW Financieel'!$T$9,0)","v":0},0]
[56,0.28764330224061913,0.20171538027487723,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A65,0,AA65=TRUE,L$9,AA65=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A65,0,AB65=TRUE,M$9,AB65=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A65,0,AC65=TRUE,N$9,AC65=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A65,0,AD65=TRUE,O$9,AD65=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A65,0,AE65=TRUE,P$9,AE65=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A65,0,AF65=TRUE,Q$9,AF65=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A65,0,AG65=TRUE,R$9,AG65=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A65-0),'NCW Financieel'!$T$9,0)","v":0},0]
[57,0.28131374302261047,0.19603049589395263,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A66,0,AA66=TRUE,L$9,AA66=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A66,0,AB66=TRUE,M$9,AB66=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A66,0,AC66=TRUE,N$9,AC66=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A66,0,AD66=TRUE,O$9,AD66=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A66,0,AE66=TRUE,P$9,AE66=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A66,0,AF66=TRUE,Q$9,AF66=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A66,0,AG66=TRUE,R$9,AG66=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A66-0),'NCW Financieel'!$T$9,0)","v":0},0]
[58,0.27512346505878776,0.19050582691346218,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A67,0,AA67=TRUE,L$9,AA67=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A67,0,AB67=TRUE,M$9,AB67=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A67,0,AC67=TRUE,N$9,AC67=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A67,0,AD67=TRUE,O$9,AD67=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A67,0,AE67=TRUE,P$9,AE67=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A67,0,AF67=TRUE,Q$9,AF67=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A67,0,AG67=TRUE,R$9,AG67=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A67-0),'NCW Financieel'!$T$9,0)","v":0},0]
[59,0.26906940348047709,0.18513685803057559,0,0,0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A68,0,AA68=TRUE,L$9,AA68=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A68,0,AB68=TRUE,M$9,AB68=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A68,0,AC68=TRUE,N$9,AC68=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A68,0,AD68=TRUE,O$9,AD68=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A68,0,AE68=TRUE,P$9,AE68=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A68,0,AF68=TRUE,Q$9,AF68=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A68,0,AG68=TRUE,R$9,AG68=FALSE,0)","v":0},0,{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A68-0),'NCW Financieel'!$T$9,0)","v":0},0]
[60,0.26314856086110222,0.17991920119589463,{"$f":"E69-K69","v":0},{"$f":"SUM(F69:I69)","v":0},0,0,0,0,null,0,{"$f":"_xlfn.IFS($Y$7=$A69,0,AA69=TRUE,L$9,AA69=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A69,0,AB69=TRUE,M$9,AB69=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A69,0,AC69=TRUE,N$9,AC69=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A69,0,AD69=TRUE,O$9,AD69=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A69,0,AE69=TRUE,P$9,AE69=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A69,0,AF69=TRUE,Q$9,AF69=FALSE,0)","v":0},{"$f":"_xlfn.IFS($Y$7=$A69,0,AG69=TRUE,R$9,AG69=FALSE,0)","v":0},{"$f":"SUM(L69:R69)","v":0},{"$f":"IF('1 Current state of the building'!$F$14=('NCW Financieel'!A69-0),'NCW Financieel'!$T$9,0)","v":0},0]
[]
[]
[]
[]
[null,null,null,null,"Subtotaal","Netto opbrengsten exploitatie rood dak","Energie opbrengsten teruglevering","Energiebesparing verbruik",null,null,"Subtotaal",null,null,null,null,null,null,null,"Meerkosten t.o.v. referentiealternatief (incl. subsidies)",null,"Beheer- en onderhoud"]
[null,null,null,null,{"$f":"E6","v":0},{"$f":"F6","v":0},{"$f":"G6","v":0},{"$f":"H6","v":0},{"$f":"I6","v":0},null,{"$f":"K7","v":0},null,null,null,null,null,null,null,{"$f":"S6","v":0},{"$f":"T9","v":0},{"$f":"U6","v":0}]
[]
[]
[]
[]
[null,null,null,"Kosten",{"$f":"K75","v":0}]
[null,null,null,"Opbrengsten",{"$f":"E75","v":0}]
[null,null,null,"Saldo",{"$f":"E81-E80","v":0}]

{"sheet":"NCW MKBA","index":6,"n_rows":79,"n_cols":22,"rows_kept":79,"cut":false,"hidden":true,"merged":[]}
[]
["NCW BEREKENING: MKBA"]
[]
[]
[null,null,null,"TOTAAL","BATEN",null,null,null,null,null,null,null,null,null,null,"KOSTEN"]
["Ncw per 1-1-2021",null,null,"Totaal","Subtotaal","Waterretentie en -hergebruik (blauw dak)","Energie-opbrengsten","Vermeden CO2 uitstoot (geel dak)","Vermeden uitstoot overig (geel dak)","Waterretentie (groen dak)","Fijnstof Afvang (groen dak)","Vermeden zorgkosten (groen dak)","Vermeden arbeidsverlies (groen dak)","Vastgoedwaarde",{"$f":"'NCW Financieel'!F5","v":"Opbrengsten exploitatie rood dak"},"Subtotaal",{"$f":"'NCW Financieel'!S5","v":"Investeringskosten"},{"$f":"'NCW Financieel'!T5","v":"Investeringskosten regulier dak (negatief)"},"Beheer- en onderhoud"]
[null,null,null,{"$f":"SUM(D$10:INDEX(D$10:D$49,MATCH($V$15,$A$10:$A$49,0)))","v":0},{"$f":"SUM(E$10:INDEX(E$10:E$69,MATCH($V$15,$A$10:$A$69,0)))","v":0},{"$f":"NPV(B9,F$10:INDEX(F$10:F$69,MATCH($V$15,$A$10:$A$69,0)))","v":0},{"$f":"NPV(B9,G$10:INDEX(G$10:G$69,MATCH($V$15,$A$10:$A$69,0)))","v":0},{"$f":"NPV(C9,H$10:INDEX(H$10:H$69,MATCH($V$15,$A$10:$A$69,0)))","v":0},{"$f":"NPV($B$9,I$10:INDEX(I$10:I$69,MATCH($V$15,$A$10:$A$69,0)))","v":0},{"$f":"NPV($B$9,J$10:INDEX(J$10:J$69,MATCH($V$15,$A$10:$A$69,0)))","v":0},{"$f":"NPV($B$9,K$10:INDEX(K$10:K$69,MATCH($V$15,$A$10:$A$69,0)))","v":0},{"$f":"NPV($B$9,L$10:INDEX(L$10:L$69,MATCH($V$15,$A$10:$A$69,0)))","v":0},{"$f":"NPV($B$9,M$10:INDEX(M$10:M$69,MATCH($V$15,$A$10:$A$69,0)))","v":0},{"$f":"NPV($B$9,N$10:INDEX(N$10:N$69,MATCH($V$15,$A$10:$A$69,0)))","v":0},null,{"$f":"SUM(Q7:S7)","v":0},{"$f":"NPV($B$9,Q$10:INDEX(Q$10:Q$69,MATCH($V$15,$A$10:$A$69,0)))","v":0},{"$f":"NPV($B$9,R$10:INDEX(R$10:R$69,MATCH($V$15,$A$10:$A$69,0)))","v":0},{"$f":"NPV($B$9,S$10:INDEX(S$10:S$69,MATCH($V$15,$A$10:$A$69,0)))","v":0}]
[null,"Normaal","CO2"]
["Discontovoet",{"$f":"'2 Design of the roof'!H192","v":2.2499999999999999E-2},2.9000000000000001E-2,null,null,{"$f":"Waterretentie!C13","v":0},{"$f":"'NCW Financieel'!G9+'NCW Financieel'!H9","v":0},{"$f":"'Luchtkwaliteit en klimaat'!E37","v":0},{"$f":"'Luchtkwaliteit en klimaat'!E38","v":0},{"$f":"'Waterretentie Groen dak'!C7","v":0},{"$f":"'Luchtkwaliteit en klimaat'!L26","v":0},{"$f":"Gezondheid!C18","v":0},{"$f":"Gezondheid!C17","v":0},{"$f":"'Imago en vestigingsklimaat'!C10","v":0},{"$f":"'NCW Financieel'!F9","v":0},null,{"$f":"'NCW Financieel'!S9","v":0},{"$f":"'NCW Financieel'!T9","v":0},{"$f":"'NCW Financieel'!U9","v":0}]
[1,0.97,{"$f":"1/(1+$C$9)^A10","v":0.97181729834791064},{"$f":"E10-P10","v":0},{"$f":"SUM(F10:O10)","v":0},{"$f":"$F$9","v":0},{"$f":"'NCW Financieel'!G10+'NCW Financieel'!H10","v":0},{"$f":"$H$9","v":0},{"$f":"$I$9","v":0},{"$f":"J9","v":0},{"$f":"$K$9","v":0},{"$f":"$L$9","v":0},{"$f":"$M$9","v":0},{"$f":"N9","v":0},{"$f":"'NCW Financieel'!F10","v":0},{"$f":"SUM(Q10:S10)","v":0},{"$f":"'NCW Financieel'!S10","v":0},{"$f":"'NCW Financieel'!T10","v":0},{"$f":"'NCW Financieel'!U10","v":0}]
[2,{"$f":"1/(1+$A$7)^A11","v":1},{"$f":"1/(1+$C$9)^A11","v":0.9444288613682319},{"$f":"E11-P11","v":0},{"$f":"SUM(F11:N11)","v":0},null,{"$f":"'NCW Financieel'!G11+'NCW Financieel'!H11","v":0},{"$f":"$H$9*1.03^(A11-$A$10)","v":0},{"$f":"$I$9","v":0},null,{"$f":"$K$9","v":0},{"$f":"$L$9","v":0},{"$f":"$M$9","v":0},null,{"$f":"'NCW Financieel'!F11","v":0},0,{"$f":"'NCW Financieel'!S11","v":0},{"$f":"'NCW Financieel'!T11","v":0},{"$f":"'NCW Financieel'!U11","v":0}]
[3,1,0.91781230453666862,0,0,{"$f":"F11*B12","v":0},{"$f":"'NCW Financieel'!G12+'NCW Financieel'!H12","v":0},{"$f":"$H$9*1.03^(A12-$A$10)","v":0},0,null,0,0,0,null,{"$f":"'NCW Financieel'!F12","v":0},0,{"$f":"'NCW Financieel'!S12","v":0},{"$f":"'NCW Financieel'!T12","v":0},{"$f":"'NCW Financieel'!U12","v":0}]
[4,1,0.89194587418529503,0,0,{"$f":"F12*B13","v":0},{"$f":"'NCW Financieel'!G13+'NCW Financieel'!H13","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F13","v":0},0,{"$f":"'NCW Financieel'!S13","v":0},{"$f":"'NCW Financieel'!T13","v":0},{"$f":"'NCW Financieel'!U13","v":0}]
[5,1,0.86680842972331895,0,0,0,{"$f":"'NCW Financieel'!G14+'NCW Financieel'!H14","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F14","v":0},0,{"$f":"'NCW Financieel'!S14","v":0},{"$f":"'NCW Financieel'!T14","v":0},{"$f":"'NCW Financieel'!U14","v":0}]
[6,1,0.8423794263589105,0,0,0,{"$f":"'NCW Financieel'!G15+'NCW Financieel'!H15","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F15","v":0},0,{"$f":"'NCW Financieel'!S15","v":0},{"$f":"'NCW Financieel'!T15","v":0},{"$f":"'NCW Financieel'!U15","v":0},null,"analyseperiode",{"$f":"'NCW Financieel'!Y7","v":40}]
[7,1,0.81863889830797909,0,0,0,{"$f":"'NCW Financieel'!G16+'NCW Financieel'!H16","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F16","v":0},0,{"$f":"'NCW Financieel'!S16","v":0},{"$f":"'NCW Financieel'!T16","v":0},{"$f":"'NCW Financieel'!U16","v":0}]
[8,1,0.79556744247617017,0,0,0,{"$f":"'NCW Financieel'!G17+'NCW Financieel'!H17","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F17","v":0},0,{"$f":"'NCW Financieel'!S17","v":0},{"$f":"'NCW Financieel'!T17","v":0},{"$f":"'NCW Financieel'!U17","v":0}]
[9,1,0.77314620260074862,0,0,0,{"$f":"'NCW Financieel'!G18+'NCW Financieel'!H18","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F18","v":0},0,{"$f":"'NCW Financieel'!S18","v":0},{"$f":"'NCW Financieel'!T18","v":0},{"$f":"'NCW Financieel'!U18","v":0}]
[10,1,0.75135685383940576,0,0,0,{"$f":"'NCW Financieel'!G19+'NCW Financieel'!H19","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F19","v":0},0,{"$f":"'NCW Financieel'!S19","v":0},{"$f":"'NCW Financieel'!T19","v":0},{"$f":"'NCW Financieel'!U19","v":0}]
[11,1,0.73018158779339737,0,0,0,{"$f":"'NCW Financieel'!G20+'NCW Financieel'!H20","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F20","v":0},0,{"$f":"'NCW Financieel'!S20","v":0},{"$f":"'NCW Financieel'!T20","v":0},{"$f":"'NCW Financieel'!U20","v":0}]
[12,1,0.7096030979527671,0,0,0,{"$f":"'NCW Financieel'!G21+'NCW Financieel'!H21","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F21","v":0},0,{"$f":"'NCW Financieel'!S21","v":0},{"$f":"'NCW Financieel'!T21","v":0},{"$f":"'NCW Financieel'!U21","v":0}]
[13,1,0.68960456555176597,0,0,0,{"$f":"'NCW Financieel'!G22+'NCW Financieel'!H22","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F22","v":0},0,{"$f":"'NCW Financieel'!S22","v":0},{"$f":"'NCW Financieel'!T22","v":0},{"$f":"'NCW Financieel'!U22","v":0}]
[14,1,0.67016964582290184,0,0,0,{"$f":"'NCW Financieel'!G23+'NCW Financieel'!H23","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F23","v":0},0,{"$f":"'NCW Financieel'!S23","v":0},{"$f":"'NCW Financieel'!T23","v":0},{"$f":"'NCW Financieel'!U23","v":0}]
[15,1,0.65128245463838852,0,0,0,{"$f":"'NCW Financieel'!G24+'NCW Financieel'!H24","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F24","v":0},0,{"$f":"'NCW Financieel'!S24","v":0},{"$f":"'NCW Financieel'!T24","v":0},{"$f":"'NCW Financieel'!U24","v":0}]
[16,1,0.63292755552807445,0,0,0,{"$f":"'NCW Financieel'!G25+'NCW Financieel'!H25","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F25","v":0},0,{"$f":"'NCW Financieel'!S25","v":0},{"$f":"'NCW Financieel'!T25","v":0},{"$f":"'NCW Financieel'!U25","v":0}]
[17,1,0.61508994706324049,0,0,0,{"$f":"'NCW Financieel'!G26+'NCW Financieel'!H26","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F26","v":0},0,{"$f":"'NCW Financieel'!S26","v":0},{"$f":"'NCW Financieel'!T26","v":0},{"$f":"'NCW Financieel'!U26","v":0}]
[18,1,0.59775505059595779,0,0,0,{"$f":"'NCW Financieel'!G27+'NCW Financieel'!H27","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F27","v":0},0,{"$f":"'NCW Financieel'!S27","v":0},{"$f":"'NCW Financieel'!T27","v":0},{"$f":"'NCW Financieel'!U27","v":0}]
[19,1,0.58090869834398229,0,0,0,{"$f":"'NCW Financieel'!G28+'NCW Financieel'!H28","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F28","v":0},0,{"$f":"'NCW Financieel'!S28","v":0},{"$f":"'NCW Financieel'!T28","v":0},{"$f":"'NCW Financieel'!U28","v":0}]
[20,1,0.56453712181145022,0,0,0,{"$f":"'NCW Financieel'!G29+'NCW Financieel'!H29","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F29","v":0},0,{"$f":"'NCW Financieel'!S29","v":0},{"$f":"'NCW Financieel'!T29","v":0},{"$f":"'NCW Financieel'!U29","v":0}]
[21,1,0.54862694053590888,0,0,0,{"$f":"'NCW Financieel'!G30+'NCW Financieel'!H30","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F30","v":0},0,{"$f":"'NCW Financieel'!S30","v":0},{"$f":"'NCW Financieel'!T30","v":0},{"$f":"'NCW Financieel'!U30","v":0}]
[22,1,0.53316515115248686,0,0,0,{"$f":"'NCW Financieel'!G31+'NCW Financieel'!H31","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F31","v":0},0,{"$f":"'NCW Financieel'!S31","v":0},{"$f":"'NCW Financieel'!T31","v":0},{"$f":"'NCW Financieel'!U31","v":0}]
[23,1,0.51813911676626512,0,0,0,{"$f":"'NCW Financieel'!G32+'NCW Financieel'!H32","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F32","v":0},0,{"$f":"'NCW Financieel'!S32","v":0},{"$f":"'NCW Financieel'!T32","v":0},{"$f":"'NCW Financieel'!U32","v":0}]
[24,1,0.5035365566241643,0,0,0,{"$f":"'NCW Financieel'!G33+'NCW Financieel'!H33","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F33","v":0},0,{"$f":"'NCW Financieel'!S33","v":0},{"$f":"'NCW Financieel'!T33","v":0},{"$f":"'NCW Financieel'!U33","v":0}]
[25,1,0.48934553607790515,0,0,0,{"$f":"'NCW Financieel'!G34+'NCW Financieel'!H34","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F34","v":0},0,{"$f":"'NCW Financieel'!S34","v":0},{"$f":"'NCW Financieel'!T34","v":0},{"$f":"'NCW Financieel'!U34","v":0}]
[26,1,0.47555445682983971,0,0,0,{"$f":"'NCW Financieel'!G35+'NCW Financieel'!H35","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F35","v":0},0,{"$f":"'NCW Financieel'!S35","v":0},{"$f":"'NCW Financieel'!T35","v":0},{"$f":"'NCW Financieel'!U35","v":0}]
[27,1,0.4621520474536831,0,0,0,{"$f":"'NCW Financieel'!G36+'NCW Financieel'!H36","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F36","v":0},0,{"$f":"'NCW Financieel'!S36","v":0},{"$f":"'NCW Financieel'!T36","v":0},{"$f":"'NCW Financieel'!U36","v":0}]
[28,1,0.44912735418239363,0,0,0,{"$f":"'NCW Financieel'!G37+'NCW Financieel'!H37","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F37","v":0},0,{"$f":"'NCW Financieel'!S37","v":0},{"$f":"'NCW Financieel'!T37","v":0},{"$f":"'NCW Financieel'!U37","v":0}]
[29,1,0.43646973195567895,0,0,0,{"$f":"'NCW Financieel'!G38+'NCW Financieel'!H38","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F38","v":0},0,{"$f":"'NCW Financieel'!S38","v":0},{"$f":"'NCW Financieel'!T38","v":0},{"$f":"'NCW Financieel'!U38","v":0}]
[30,1,0.42416883571980463,0,0,0,{"$f":"'NCW Financieel'!G39+'NCW Financieel'!H39","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F39","v":0},0,{"$f":"'NCW Financieel'!S39","v":0},{"$f":"'NCW Financieel'!T39","v":0},{"$f":"'NCW Financieel'!U39","v":0}]
[31,1,0.41221461197259929,0,0,0,{"$f":"'NCW Financieel'!G40+'NCW Financieel'!H40","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F40","v":0},0,{"$f":"'NCW Financieel'!S40","v":0},{"$f":"'NCW Financieel'!T40","v":0},{"$f":"'NCW Financieel'!U40","v":0}]
[32,1,0.40059729054674376,0,0,0,{"$f":"'NCW Financieel'!G41+'NCW Financieel'!H41","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F41","v":0},0,{"$f":"'NCW Financieel'!S41","v":0},{"$f":"'NCW Financieel'!T41","v":0},{"$f":"'NCW Financieel'!U41","v":0}]
[33,1,0.3893073766246295,0,0,0,{"$f":"'NCW Financieel'!G42+'NCW Financieel'!H42","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F42","v":0},{"$f":"SUM(Q42:S42)","v":0},{"$f":"'NCW Financieel'!S42","v":0},{"$f":"'NCW Financieel'!T42","v":0},{"$f":"'NCW Financieel'!U42","v":0}]
[34,1,0.37833564297825995,0,0,0,{"$f":"'NCW Financieel'!G43+'NCW Financieel'!H43","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F43","v":0},0,{"$f":"'NCW Financieel'!S43","v":0},{"$f":"'NCW Financieel'!T43","v":0},{"$f":"'NCW Financieel'!U43","v":0}]
[35,1,0.36767312242785233,0,0,0,{"$f":"'NCW Financieel'!G44+'NCW Financieel'!H44","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F44","v":0},0,{"$f":"'NCW Financieel'!S44","v":0},{"$f":"'NCW Financieel'!T44","v":0},{"$f":"'NCW Financieel'!U44","v":0}]
[36,1,0.35731110051297599,0,0,0,{"$f":"'NCW Financieel'!G45+'NCW Financieel'!H45","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F45","v":0},0,{"$f":"'NCW Financieel'!S45","v":0},{"$f":"'NCW Financieel'!T45","v":0},{"$f":"'NCW Financieel'!U45","v":0}]
[37,1,0.34724110837023908,0,0,0,{"$f":"'NCW Financieel'!G46+'NCW Financieel'!H46","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F46","v":0},0,{"$f":"'NCW Financieel'!S46","v":0},{"$f":"'NCW Financieel'!T46","v":0},{"$f":"'NCW Financieel'!U46","v":0}]
[38,1,0.33745491581169978,0,0,0,{"$f":"'NCW Financieel'!G47+'NCW Financieel'!H47","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F47","v":0},0,{"$f":"'NCW Financieel'!S47","v":0},{"$f":"'NCW Financieel'!T47","v":0},{"$f":"'NCW Financieel'!U47","v":0}]
[39,1,0.32794452459834766,0,0,0,{"$f":"'NCW Financieel'!G48+'NCW Financieel'!H48","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F48","v":0},0,{"$f":"'NCW Financieel'!S48","v":0},{"$f":"'NCW Financieel'!T48","v":0},{"$f":"'NCW Financieel'!U48","v":0}]
[40,1,0.3187021619031562,0,0,0,{"$f":"'NCW Financieel'!G49+'NCW Financieel'!H49","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F49","v":0},0,{"$f":"'NCW Financieel'!S49","v":0},{"$f":"'NCW Financieel'!T49","v":0},{"$f":"'NCW Financieel'!U49","v":0}]
[41,{"$f":"1/(1+$A$7)^A50","v":1},0.30972027395836371,0,0,{"$f":"F49*B50","v":0},{"$f":"'NCW Financieel'!G50+'NCW Financieel'!H50","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F50","v":0},0,{"$f":"'NCW Financieel'!S50","v":0},{"$f":"'NCW Financieel'!T50","v":0},{"$f":"'NCW Financieel'!U50","v":0}]
[42,1,0.30099151988179168,0,0,0,{"$f":"'NCW Financieel'!G51+'NCW Financieel'!H51","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F51","v":0},0,{"$f":"'NCW Financieel'!S51","v":0},{"$f":"'NCW Financieel'!T51","v":0},{"$f":"'NCW Financieel'!U51","v":0}]
[43,1,0.29250876567715428,0,0,0,{"$f":"'NCW Financieel'!G52+'NCW Financieel'!H52","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F52","v":0},0,{"$f":"'NCW Financieel'!S52","v":0},{"$f":"'NCW Financieel'!T52","v":0},{"$f":"'NCW Financieel'!U52","v":0}]
[44,1,0.28426507840345411,0,0,0,{"$f":"'NCW Financieel'!G53+'NCW Financieel'!H53","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F53","v":0},0,{"$f":"'NCW Financieel'!S53","v":0},{"$f":"'NCW Financieel'!T53","v":0},{"$f":"'NCW Financieel'!U53","v":0}]
[45,1,0.27625372050870178,0,0,0,{"$f":"'NCW Financieel'!G54+'NCW Financieel'!H54","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F54","v":0},0,{"$f":"'NCW Financieel'!S54","v":0},{"$f":"'NCW Financieel'!T54","v":0},{"$f":"'NCW Financieel'!U54","v":0}]
[46,1,0.26846814432332533,0,0,0,{"$f":"'NCW Financieel'!G55+'NCW Financieel'!H55","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F55","v":0},0,{"$f":"'NCW Financieel'!S55","v":0},{"$f":"'NCW Financieel'!T55","v":0},{"$f":"'NCW Financieel'!U55","v":0}]
[47,1,0.26090198670877096,0,0,0,{"$f":"'NCW Financieel'!G56+'NCW Financieel'!H56","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F56","v":0},0,{"$f":"'NCW Financieel'!S56","v":0},{"$f":"'NCW Financieel'!T56","v":0},{"$f":"'NCW Financieel'!U56","v":0}]
[48,1,0.25354906385692033,0,0,0,{"$f":"'NCW Financieel'!G57+'NCW Financieel'!H57","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F57","v":0},0,{"$f":"'NCW Financieel'!S57","v":0},{"$f":"'NCW Financieel'!T57","v":0},{"$f":"'NCW Financieel'!U57","v":0}]
[49,1,0.2464033662360742,0,0,0,{"$f":"'NCW Financieel'!G58+'NCW Financieel'!H58","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F58","v":0},0,{"$f":"'NCW Financieel'!S58","v":0},{"$f":"'NCW Financieel'!T58","v":0},{"$f":"'NCW Financieel'!U58","v":0}]
[50,1,0.23945905367937237,0,0,0,{"$f":"'NCW Financieel'!G59+'NCW Financieel'!H59","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F59","v":0},0,{"$f":"'NCW Financieel'!S59","v":0},{"$f":"'NCW Financieel'!T59","v":0},{"$f":"'NCW Financieel'!U59","v":0}]
[51,1,0.23271045061163501,0,0,0,{"$f":"'NCW Financieel'!G60+'NCW Financieel'!H60","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F60","v":0},0,{"$f":"'NCW Financieel'!S60","v":0},{"$f":"'NCW Financieel'!T60","v":0},{"$f":"'NCW Financieel'!U60","v":0}]
[52,1,0.22615204141072398,0,0,0,{"$f":"'NCW Financieel'!G61+'NCW Financieel'!H61","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F61","v":0},0,{"$f":"'NCW Financieel'!S61","v":0},{"$f":"'NCW Financieel'!T61","v":0},{"$f":"'NCW Financieel'!U61","v":0}]
[53,1,0.2197784658996346,0,0,0,{"$f":"'NCW Financieel'!G62+'NCW Financieel'!H62","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F62","v":0},0,{"$f":"'NCW Financieel'!S62","v":0},{"$f":"'NCW Financieel'!T62","v":0},{"$f":"'NCW Financieel'!U62","v":0}]
[54,1,0.2135845149656313,0,0,0,{"$f":"'NCW Financieel'!G63+'NCW Financieel'!H63","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F63","v":0},0,{"$f":"'NCW Financieel'!S63","v":0},{"$f":"'NCW Financieel'!T63","v":0},{"$f":"'NCW Financieel'!U63","v":0}]
[55,1,0.20756512630284871,0,0,0,{"$f":"'NCW Financieel'!G64+'NCW Financieel'!H64","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F64","v":0},0,{"$f":"'NCW Financieel'!S64","v":0},{"$f":"'NCW Financieel'!T64","v":0},{"$f":"'NCW Financieel'!U64","v":0}]
[56,1,0.20171538027487723,0,0,0,{"$f":"'NCW Financieel'!G65+'NCW Financieel'!H65","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F65","v":0},0,{"$f":"'NCW Financieel'!S65","v":0},{"$f":"'NCW Financieel'!T65","v":0},{"$f":"'NCW Financieel'!U65","v":0}]
[57,1,0.19603049589395263,0,0,0,{"$f":"'NCW Financieel'!G66+'NCW Financieel'!H66","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F66","v":0},0,{"$f":"'NCW Financieel'!S66","v":0},{"$f":"'NCW Financieel'!T66","v":0},{"$f":"'NCW Financieel'!U66","v":0}]
[58,1,0.19050582691346218,0,0,0,{"$f":"'NCW Financieel'!G67+'NCW Financieel'!H67","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F67","v":0},0,{"$f":"'NCW Financieel'!S67","v":0},{"$f":"'NCW Financieel'!T67","v":0},{"$f":"'NCW Financieel'!U67","v":0}]
[59,1,0.18513685803057559,0,0,0,{"$f":"'NCW Financieel'!G68+'NCW Financieel'!H68","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F68","v":0},0,{"$f":"'NCW Financieel'!S68","v":0},{"$f":"'NCW Financieel'!T68","v":0},{"$f":"'NCW Financieel'!U68","v":0}]
[60,1,0.17991920119589463,0,0,0,{"$f":"'NCW Financieel'!G69+'NCW Financieel'!H69","v":0},0,0,null,0,0,0,null,{"$f":"'NCW Financieel'!F69","v":0},0,{"$f":"'NCW Financieel'!S69","v":0},{"$f":"'NCW Financieel'!T69","v":0},{"$f":"'NCW Financieel'!U69","v":0}]
[]
[null,null,null,null,"Subtotaal","Waterretentie",null,"Klimaat","Luchtkwaliteit",null,null,"Gezondheidseffect: vermeden zorgkosten","Gezondheidseffect: vermeden arbeidsverlies",null,null,"Subtotaal","Meerkosten t.o.v. ref. alternatief (excl. subsidies)",null,"Beheer- en onderhoud"]
[null,null,null,null,{"$f":"E7","v":0},{"$f":"F7","v":0},null,{"$f":"H7","v":0},{"$f":"I7","v":0},null,null,{"$f":"L7","v":0},{"$f":"M7","v":0},null,null,{"$f":"P7","v":0},{"$f":"Q7","v":0},null,{"$f":"S7","v":0}]
[]
[]
[]
[]
[null,null,null,"Kosten",{"$f":"P72","v":0}]
[null,null,null,"Baten",{"$f":"E72","v":0}]
[null,null,null,"Saldo",{"$f":"E78-E77","v":0}]

{"sheet":"Prijspeil","index":7,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[null,null,2005,84.88]
[null,null,2006,85.82]
[null,null,2007,87.2]
[null,null,2008,89.37]
[null,null,2009,90.44]
[null,null,2010,91.59]
[null,null,2011,93.73]
[null,null,2012,96.04]
[null,null,2013,98.44]
[null,null,2014,99.4]
[null,null,2015,100]
[null,null,2016,100.32]
[null,null,2017,101.7]
[null,null,2018,103.44]
[null,null,2019,106.16]
[null,null,2020,107.51]

{"sheet":"Waterretentie Groen dak","index":8,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
[null,"Waterretentie"]
[]
[null,"Retentie"]
[null,"Waardering (schaduwprijs) waterretentie in stedelijk gebied HHSK",{"$f":"500*(Prijspeil!D21/Prijspeil!D18)","v":528.56440511307767},"euro per m3","Zie ook 7SE"]
[]
[null,"Waterberging totaal",{"$f":"H20*H21/1000","v":0},"m3"]
[null,"Waterberging",{"$f":"C4*C6","v":0},"Eenmalig"]
[]
[]
[]
[null,"Alleen bij MKBA! = geen subsidie (dus niet bij financiele businesscase)"]
[]
[null,"Totale baat waterretentie",{"$f":"C7","v":0},"Eenmalig! In beginjaar"]
[]
[]
[]
[]
[null,"Blauwe daken vangen water op. Ze spelen een belangrijke rol bij erg nat of juist droog weer."]
[null,null,null,null,null,null,null,"Invoer"]
[null,null,null,null,"Hoeveel vierkante meter waterberging legt u aan?",null,null,{"$f":"'2 Design of the roof'!H22","v":0},"m²"]
[null,null,null,null,"Hoeveel mm water bergt u op het dak?",null,null,10,"mm"]

{"sheet":"Waterretentie","index":9,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[null,"Waterretentie"]
[]
[null,"Retentie"]
[null,"Waardering (schaduwprijs) waterretentie in stedelijk gebied HHSK",{"$f":"IF('2 Design of the roof'!H69=\"Ja\",500*C6*(Prijspeil!D21/Prijspeil!D18),0)","v":0},"euro per m3","Zie ook 7SE"]
[]
[null,"Waterberging totaal",{"$f":"'2 Design of the roof'!H73/1000*'2 Design of the roof'!H72","v":0},"m3"]
[null,"Waterhergebruik",{"$f":"IF('2 Design of the roof'!H78=\"Ja\",'2 Design of the roof'!H79/1000*'2 Design of the roof'!H80*(Prijspeil!D21/Prijspeil!D20),0)","v":0},"per jaar","Prijspeil 2020"]
[]
[]
[]
[null,"Alleen bij MKBA! = geen subsidie (dus niet bij financiele businesscase)"]
[]
[null,"Totale baat waterretentie",{"$f":"(C4)","v":0},"Eenmalig! In beginjaar"]
[null,"Totale baat waterhergebruik",{"$f":"(C6*C7)","v":0},"per jaar"]

{"sheet":"Luchtkwaliteit en klimaat","index":10,"n_rows":40,"n_cols":21,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
[null,"Luchtkwaliteit en klimaat"]
[]
[null,"Luchtkwaliteit en klimaat","Project","Referentie","Per saldo",null,"https://www.rivm.nl/bibliotheek/rapporten/2019-0011.pdf",null,null,null,"Afvangen Fijnstof met Groen dak"]
[null,"Jaarlijkse CO2 winst ",{"$f":"'Luchtkwaliteit en klimaat'!$C$29*C12*C19*(Prijspeil!$D$21/Prijspeil!$D$19)","v":0},0,{"$f":"C4-D4","v":0},null,null,null,null,null,"Oppervlakte groen dak",{"$f":"'2 Design of the roof'!H62","v":0},"m2"]
[null,"Jaarlijkse Nox reductie ",{"$f":"'Luchtkwaliteit en klimaat'!$C$29*C13*C20*(Prijspeil!$D$21/Prijspeil!$D$19)","v":0},0,{"$f":"C5-D5","v":0},null,"Gerelateerd aan geel/elektriciteit/zonnepanelen",null,null,null,"Binnen of buiten de bebouwde kom?","Binnen"]
[null,"Jaarlijkse SO2 reductie ",{"$f":"'Luchtkwaliteit en klimaat'!$C$29*C14*C21*(Prijspeil!$D$21/Prijspeil!$D$19)","v":0},0,{"$f":"C6-D6","v":0}]
[null,"Jaarlijkse VOS reductie ",{"$f":"'Luchtkwaliteit en klimaat'!$C$29*C15*C22*(Prijspeil!$D$21/Prijspeil!$D$19)","v":0},0,{"$f":"C7-D7","v":0},null,null,null,null,null,null,{"$f":"L4*0.0001","v":0},"ha"]
[null,"Jaarlijkse fijn stof reductie",{"$f":"'Luchtkwaliteit en klimaat'!$C$29*C16*C23*(Prijspeil!$D$21/Prijspeil!$D$19)","v":0},0,{"$f":"C8-D8","v":0}]
[]
[null,"Kengetallen",null,null,null,null,null,null,null,null,"Kengetallen"]
[null,"Vermeden uitstoot",null,null,null,null,null,null,null,null,"Eenheidscorrectie cm/s naar kg/ha/jaar",3.1536,"(-)"]
[null,"CO2 ",0.69,"kg/kWh","NEV (2017)",null,null,null,null,null,"Depositiesnelheid Fijnstof Groene Daken",0.33,"cm/s"]
[null,"NOX",{"$f":"0.71/1000","v":7.0999999999999991E-4},"kg/kWh","CE Delft (2014)",null,null,null,null,null,"Maatschappelijke waarde Fijnstof",45.22,"€/kg"]
[null,"SO2",{"$f":"0.39/1000","v":3.8999999999999999E-4},"kg/kWh","CE Delft (2014)",null,null,null,null,null,"Totaal:",{"$f":"L13*L12*$L$11*$L$7","v":0}]
[null,"VOS",{"$f":"0.56/1000","v":5.6000000000000006E-4},"kg/kWh","CE Delft (2014)",null,null,null,null,null,"Depositiesnelheid Stikstofdioxide Groene Daken",0.5,"cm/s"]
[null,"Fijn stof",{"$f":"0.03/1000","v":2.9999999999999997E-5},"kg/kWh","CE Delft (2014)",null,null,null,null,null,"Maatschappelijke waarde Stikstofdioxide",35.18,"€/kg"]
[null,null,null,null,null,null,null,null,null,null,"Totaal:",{"$f":"L16*L15*$L$11*$L$7","v":0}]
[null,"Milieuprijzen",null,null,null,null,null,null,null,null,"Depositiesnelheid Zwaveldioxide Groene Daken",0.72,"cm/s"]
[null,"CO2 ",4.8000000000000001E-2,"Euro/kg","CE Delft (2018)",null,null,null,null,null,"Maatschappelijke waarde Zwaveldioxide",25.24,"€/kg"]
[null,"NOX",35,"Euro/kg","CE Delft (2018)",null,null,null,null,null,"Totaal:",{"$f":"L19*L18*$L$11*$L$7","v":0}]
[null,"SO2",24.4,"Euro/kg","CE Delft (2018)",null,null,null,null,null,"Depositiesnelheid Ozon Groene Daken",0.75,"cm/s"]
[null,"VOS",2.29,"Euro/kg","CE Delft (2018)",null,null,null,null,null,"Maatschappelijke waarde Ozon",4.24,"€/kg"]
[null,"Fijn stof",43.5,"Euro/kg","CE Delft (2018)",null,null,null,null,null,"Totaal:",{"$f":"L22*L21*$L$11*$L$7","v":0}]
[]
[null,"Aannames"]
[null,"Energieopbrengst per paneel",300,"Wp",null,null,"https://www.zonnepanelen-weetjes.nl/prijzen-zonnepanelen/",null,null,null,"Totale Maatschappelijke waarde:",{"$f":"SUM(L23,L20,L17,L14)","v":0},"per jaar"]
[null,"Aantal panelen",{"$f":"'2 Design of the roof'!H93","v":0},"stuks",null,null,{"$f":"'2 Design of the roof'!Q97","v":"https://www.zonneplan.nl/kenniscentrum/zonnepanelen/levensduur"}]
[null,"Correctiefactor efficiëntie  panelen",0.9,"(-)",null,null,{"$f":"IF(ISNUMBER(SEARCH(\"Zuid\", '2 Design of the roof'!#REF!)), 0.9, 0.5)","v":0.5}]
[null,"Aanname kWh opwekking zonnepanelen",{"$f":"C26*C27*C28","v":0},"kWh per jaar"]
[null,"Gebruikte energie (kWh)",{"$f":"'2 Design of the roof'!H113","v":0}]
[null,"Maatschappelijk rendement ",3]
[null,"Levensduur dak",{"$f":"'2 Design of the roof'!H97","v":25}]
[null,"Prijs kWh stroom",{"$f":"'2 Design of the roof'!H100/1.21","v":0.18181818181818182},"Exclusief BTW (21%)"]
[]
[null,"Baten per jaar",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Depositiesnelheid"]
[null,"Energieopbrengst Zonnepanelen",null,null,{"$f":"C33*C29","v":0}]
[null,"CO2 winst",null,null,{"$f":"E4","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stikstofdioxide"]
[null,"Luchtkwaliteit",null,null,{"$f":"SUM(E5:E8)","v":0}]
[]
[null,"Totaal baten per jaar (lucht kwaliteit en klimaat)",null,null,{"$f":"SUM(E4:E8)","v":0}]

{"sheet":"Gezondheid","index":11,"n_rows":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
[null,"Gezondheidseffect door meerdere factoren"]
[]
[null,"Gezondheidseffect",null,null,"Bron"]
[null,"Kengetallen"]
[null,"Minder patiënten per 1000 inwoners bij 1% meer groen binnen 1 km",0.83499999999999996,"patiënten","Maas e.a. 2009"]
[null,"Zorgkosten",{"$f":"917*(Prijspeil!D21/Prijspeil!D8)","v":1130.5810779816513},"euro per patiënt","KPMG 2012; RIVM 2007"]
[null,"Voorkomen arbeidsverlies",{"$f":"6679*(Prijspeil!D21/Prijspeil!D20)","v":6763.9345327807087},"per patient","CBS2019"]
[]
[null,"Aannames"]
[null,"Minder patiënten per 1000 inwoners bij 1% meer groen binnen 200 m",{"$f":"C5/5","v":0.16699999999999998},"Dit is 1/5 van 0,835"]
[null,"Percentage meer groen door dak",0.01]
[]
[null,"Minder patiënten bij 1% meer groen binnen 2000",{"$f":"(C10/1000)*C14","v":2.5049999999999999E-2}]
[null,"Aantal personen met uitzicht op dak",150,"personen"]
[]
[null,"Baten per jaar"]
[null,"Vermeden zorgkosten ",{"$f":"IF(C20>0,C13*C6,0)","v":0},"euro per jaar"]
[null,"Minder arbeidsverlies",{"$f":"IF(C20>0.1,C13*C7,0)","v":0},"euro per jaar"]
[]
[null,"Aantal groenvlakken op het dak",{"$f":"IF(('2 Design of the roof'!H62)>1,1,0)","v":0}]
[]
[null,"TOTAAL GEZONDHEIDSEFFECT",{"$f":"IF(C20=1,(C17+C18),0)","v":0},"euro per jaar"]
[]
[]
[]
[null,"Gezondheid updaten met getallen uit TEEBstad"]
[null,"https://www.rivm.nl/bibliotheek/rapporten/2019-0011.pdf"]

{"sheet":"Imago en vestigingsklimaat","index":12,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
[null,"Meerdere indicatoren voor effect op imago en vestigingsklimaat"]
[]
[null,"Vastgoedwaarde",null,null,null,null,null,"https://www.rivm.nl/bibliotheek/rapporten/2019-0011.pdf"]
[null,"Uitzicht op groen leidt tot stijging woningwaarde in een van range 1,4-20% uit literatuur (zie: https://www.ncbi.nlm.nih.gov/pmc/articles/PMC3524597/)"]
[null,"Aanname (middenwaarde)",{"$f":"_xlfn.IFS(C8<501,1.4%,C8<1001,2.5%,C8<2001,5%,C8<3001,7.5%,C8<4001,10%,C8<5001,12.5%,C8<6001,15%,C8<7001,17.5%,C8<8001,20%)","v":1.3999999999999999E-2},null,"De vastgoedwaarde stijging reflecteert de volgende sub-effecten: esthetische waardering, geluiddemping, productiviteit en comfort). "]
[null,"WOZ waarde",{"$f":"'1 Current state of the building'!F26","v":0}]
[]
[null,"Aantal groenvlakken op het dak",{"$f":"'2 Design of the roof'!H62","v":0}]
[]
[null,"Totale baat vastgoedwaarde",{"$f":"IF(C8>=1,C6*C5,0)","v":0},"euro op het moment dat het pand verkocht wordt (aanname: in jaar 2)"]
[]
[null,"Leegstand"]
[null,"Gemiddelde leegstand","nvt","%"]
[null,"Gederfde huurinkomsten"]
[null,"Totale baat verminderde leegstand",null,"euro per jaar"]
[]
[null,"Totale baat verminderde leegstand",0,"euro per jaar"]
[]
[]
[null,"Imago eigenaar: kwalitatief"]
[]
[null,"Vestigingsklimaat van de wijk en stad: kwalitatief"]